I am trying to create a report using an oracle stored procedure as the data source. I have created the stored procedure and checked its result in sql plus.
when I choose the stored procedure in the data explorer dialog box and click Add, CR prompts to enter the parameter value. The procedure is based on center_id. when I enter the parameter value as say '00509' (which is the id of one of the centers) I get the following error :
ODBC error : [Microsoft][ODBC driver for Oracle]Cannot bind PL/SQL Records or Cursor References.
What am I doing wrong. I would really appreciate if someone could help me.
Thanks..viji.
when I choose the stored procedure in the data explorer dialog box and click Add, CR prompts to enter the parameter value. The procedure is based on center_id. when I enter the parameter value as say '00509' (which is the id of one of the centers) I get the following error :
ODBC error : [Microsoft][ODBC driver for Oracle]Cannot bind PL/SQL Records or Cursor References.
What am I doing wrong. I would really appreciate if someone could help me.
Thanks..viji.