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
Scott
-----Original Message-----
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 1:05 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
No, by default this package will be created under the user who
compiles it (the schema owner). Janet what are you thoughts on the
variable type? I haven't been able to return a ref cursour when its
specified as just OUT.
I still think the account they are giving you isnt kosher. Atleast if
you test it as the schema owner, it can rule that out.
-Adam
_____________________________________
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
