Error i cannot make sense of [message #643] |
Mon, 25 February 2002 12:02 |
Christian
Messages: 15 Registered: February 2001
|
Junior Member |
|
|
I am trying to compile this proc:
CREATE or REPLACE PROCEDURE INSERT_TRAINING_CLASS
( all the inputs here)
AS
total integer;
BEGIN
SELECT Count(item_id) into total from PROJECT_WMS_TEMP where item_id = ITEM_ID;
IF total = 0 THEN
BUILD_PROJECT_WMS_TEMP;
End If;
INSERT INTO TRAININGCLASS rest of insert here;
UPDATE CLASSACTIVITY rest of update here;
END;
i am getting this error: PLS-00201: identifier 'TRAININGCLASS' must be declared
The table exists so i don't know what might be causing the error with that proc.
Thanks
Christian
|
|
|
Re: Error i cannot make sense of [message #659 is a reply to message #643] |
Tue, 26 February 2002 02:02 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
have u got the necessary privillege on that table.try schema_name.table_name.
PLS-00201 identifier name must be declared
Cause: An attempt was made to reference an undefined variable, exception, procedure, function, or other object. Either the identifier was not declared or it was not within the scope of the reference.
Action: Check the spelling and declaration of the identifier. Also confirm that the declaration is placed correctly in the block structure.
|
|
|