Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Passing multiple parameters to an Oracle procedure

I'm having trouble passing multiple parameters to a stored procedure in Crystal Reports 2008 (12.2.0.290).

I'm using an OLE DB (ADO) connection to an Oracle 10g database.

I have created a stored procedure that has 3 parameters (in out sys_refcursor, in varchar2, in varchar2) and conforms to all of Crystal Reports' requirements for stored procedures.

When I select my stored procedure in the Database Expert, it prompts me to enter values for both varchar2 parameters. I enter values and everything seems fine. I close the Database Expert.

Now the stored procedure is listed in the Field Explorer, but I cannot expand the list of fields. There is a plus sign next to the stored procedure, but clicking on it does nothing. I do not get any error messages.

If I remove one of the parameters from the stored procedure and try again, everything works fine. I've also tried using a variety of parameter types, but this problem occurs every time there are 2 or more parameters (3 including the ref cursor).

Please help.

Former Member
Not what you were looking for? View more on this topic or Ask a question