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
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