Oracle Packages and Crystal Reports

From: BARU <brkprasad_at_strabus.com>
Date: 20 Sep 2002 02:31:32 -0700
Message-ID: <61c8d235.0209200131.5321b39d@posting.google.com>

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

Received on Fri Sep 20 2002 - 04:31:32 CDT