Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error connecting Oracle Stored Procedure in Package

Status
Not open for further replies.

manip

Programmer
Jan 23, 2002
1
HK
I am using Oracle 8i and Crystal Reports 8.5

I have just written an Oracle stored procedure "RPT_GET_RECORD" and
place it in a package. In the stored procedure, I just retrieve
fields from serveral tables and I have not used any function nor
called another procedure. I want to connect the stored procedure
from crystal reports.

Here is my steps:
1. Create a package with a IN OUT cursor inside.
2. Create another package storing the stored procedure using the IN
OUT cursor above.
3. Create an ODBC connection using a System DSN of type CROR8V36 (CR
Oracle8 v3.6 driver), with the option "Procedure Returns Results"
selected.
4. Create a new report at Crystal Reports.
5. In the report, select the ODBC connection above and it displays
the Oracle stored procedure created in step 2.
6. When I try to select the Oracle stored procedure, I get the error
"wrong number or types of arguments in call to RPT_GET_RECORD"

However, when I recreate the stored procedure without placing it in a
package, it works fine without any error. Any idea? Please help.
Thanks.


- Man Ip
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top