That makes sense. I was able to get it to run in sql*plus now by doing:
VARIABLE rs REFCURSOR
execute :rs := test01.testpckg(:rs);
print rs
Thanks,
Scott
-----Original Message-----
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 15, 2004 9:36 AM
To: CF-Talk
Subject: RE: Oracle Stored Procedures
Scott -
This test would fail because you did not pass a parameter to the
procedure
that is expecting. It is not the same situation as in your CF code. To
adequately test this, you need to set up the call to the procedure from
SQL*Plus that passes in a refcursor parameter.
Janet.
At 03:42 PM 9/14/2004 -0400, you wrote:
>Adam,
>I am thinking you may be right based on my last post regarding the
>EXECUTE privilege.
>
>
>Running it from SQL*PLUS has the same results:
>
>
>SQL> exec test01.testpckg;
>BEGIN test01.testpckg; END;
>
>
> *
>ERROR at line 1:
>ORA-06550: line 1, column 7:
>PLS-00306: wrong number or types of arguments in call to 'TESTPCKG'
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
