Error when using oracle stored procedure.

[viji123]

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.

 

[Guest_imported]

In Stored procedure, the first parameter should be REF CURSOR

 

[viji123]

Hi,
Thanks. I have a ref cursor as my first parameter, still its not working. When I use the stored procedure in CR , to create a new report, I am prompted to enter parameter value. when I enter the value, I get the following error :
Cannot bind pl/sql records or cursor references. Anyone with any suggestion to get this to work will be greatly appreciated.
Thanks..Viji.

 

[crystalhelp]

I know this post is more than a few months old, but if anyone knows the answer or if the person who posted this figured it out, can you let mw know the fix.

 

[Naith]

You need to go here:

http://support.crystaldecisions.com/docs

and read this:

SCR_Oracle_Stored_Procedures.pdf

Oracle stored procedures and Crystal are very specific about the way they relate.

Naith