Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00201: must be declared

604542May 21 2008 — edited May 21 2008
Hi. I've got a procedure that calls a package to read a variable. It works fine when I run the procedure in my schema account. When I run the procedure in a non schema account it complains. I've granted execute permissions of the package and stored procedure in the new account. This is the error I'm getting

CUR_OUT GPLINTERFACE.CUR_CLASSES;
*
ERROR at line 5:
ORA-06550: line 5, column 15:
PLS-00201: identifier 'GPLINTERFACE.CUR_CLASSES' must be declared
ORA-06550: line 5, column 15:
PL/SQL: Item ignored
ORA-06550: line 14, column 19:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 10, column 8:
PL/SQL: Statement ignored




The beginning on my procedure is as follows:

CREATE OR REPLACE PROCEDURE GPLTRANSACT.UPGET_ROLLOVERSTATUS (
BusinessDate DATE,
RollOverStatus IN OUT NUMBER,
UserId NUMBER,
cur_out IN OUT GPLINTERFACE.CUR_CLASSES) ---->FAILS at this line
AS
v_GUID VARCHAR(32);
ActionId NUMBER;
TodayCOBDate DATE;
TodayMinRollDate DATE;
ServerDate DATE;
LondonDate DATE;
ReturnResultSet NUMBER;
BatchTimestamp DATE;
ProcName VARCHAR2(50);
v_exists_flag NUMBER := 0; --Added by Frank 20070126
cur_empty GPLINTERFACE.CUR_CLASSES; -- Added by Frank 20070126. Fake cursor.
BEGIN


This is the definition of the package:

CREATE OR REPLACE PACKAGE GPLSQLLOADER.GPLINTERFACE as
TYPE CUR_CLASSES IS REF CURSOR;
V_SUCCESSFUL NUMBER := 1;
V_UNSUCCESSFUL NUMBER := 0;
end;
/

It works fine in the schema but once I move to my new account is does not like the CUR_CLASSES

Have I missed a privilege somewhere ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2008
Added on May 21 2008
8 comments
2,863 views