Re: Oracle Packages and Crystal Reports

BARU wrote:

> Hi ,
>
> Can and one Solve this Problem which i am getting in Oracle/Crystal
> Reports.
>
>
> I am using Crystal Reports Version 8i. I had written a Package in
> Oracle. I am trying to Connect to Oracle Database thru User/System
> DSN. I am able to Connect to the Database, but when i am attaching
> this Package to the Report, it is Giving me the Error that
>
> ERROR WHILE ATTACHING TO THE REPORT:
>
> "ODBC error:[MICROSOFT]:[ODBC DRIVER FOR ORACLE]:ORA-06550 AT LINE 1,
> COLUMN -25
> PL-00306:WRONG NUMBER OR TYPES OF ARGUMENTS IN CALL OF 'GETDTA'
> ORA-06550:LINE-1, COLUMN-7
> PL/SQL:STATEMENT IGNORED"
>
> I will be pasting a sample Code, So that if any one try and help me
> out in solving this Problem.
>
> ================================================================
> CREATE OR REPLACE PACKAGE Test IS TYPE tmpcur IS REF CURSOR;
> PROCEDURE GetData(Flst VARCHAR2,
> PCur OUT TMPCUR);
> END Test;
> /
>
> CREATE OR REPLACE PACKAGE BODY Test AS
> PROCEDURE GetData(Flst VARCHAR2,
> PCur OUT TMPCUR)
> IS
> strSQL VARCHAR2(2000);
> BEGIN
> strSQL :='SELECT ' || Flst || ' FROM TAB';
> OPEN PCur FOR strSQL;
> END getdata;
> END Test;
> /
>
> ================================================================
>
>
> STEPS TO BE FOLLOWED :
> 1. EXECUTE THE SCRIPT PACKAGE IN ORACLE 8i DATABASE.
> 2. CREATE A USER DSN SAY EX:MYTEST
> 3. TRY TO CONNECT TO ORACLE WITH THE DSN (MYTEST) FROM CRYSTAL
> REPORTS.
> 4. AFTER THE CONNECTION IS BEEN ESTABLISHED SELECT THE OPTION STORED
> PROCEDURES.
> 5. IN THAT SELECT THE PROCEDURE/PACKAGE NAMED "TEST"
>
> THEN U WE WILL GET THE ERROR MESSAGE WHICH I HAVE TYPED.
>
> IF ANY ONE CAN SOLVES THIS ISSUE,then it makes me relief as it is more
> important for my project to proceed further.
> waiting for ur responses..
>
> Thanxs & Regards,
> B.Ramakrishna Prasad(BARU)
>
>
>
> U CAN MAIL ME AT:
> brkprasad_at_strabus.com
> baruprasad_at_yahoo.com
> baruprasad_at_mailcity.com
> baruprasad_at_hotmail.com

Crystal Reports requires that REF CURSORS be IN OUT parameters. This is clearly stated on Seagate's web site if you look up Oracle Stored Procedures.

And no I haven't a clue why.

Daniel Morgan Received on Fri Sep 20 2002 - 10:21:41 CDT