Re: Oracle Packages and Crystal Reports

Your Proc expects to get an Incoming value for Flst and apparently is not getting it

• Look at the Crystal Docs for info on passing a parameter to an Oracle SP..

brkprasad_at_strabus.com (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

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Sep 20 2002 - 08:44:42 CDT