PLSQL Error [message #10083] |
Fri, 02 January 2004 01:11 |
Srini
Messages: 28 Registered: November 2000
|
Junior Member |
|
|
I am connecting to the database and i get this error message. I am new to PL/SQL. can any one help.
Error at line 353, column 3 in file .pcSzExwrt.pc
EXEC SQL DELETE J44RVTMP
..1
PLS-S-00201, identifier 'J44RVTMP' must be declared
Error at line 353, column 3 in file .pcSzExwrt.pc
EXEC SQL DELETE J44RVTMP
|
|
|
Re: PLSQL Error [message #10085 is a reply to message #10083] |
Fri, 02 January 2004 06:25 |
William Robertson
Messages: 1643 Registered: August 2003 Location: London, UK
|
Senior Member |
|
|
Odd, I don't see any PL/SQL so wondering why you get a PLS error message.
PLS-00201 identifier 'string' must be declared
Cause:
An attempt was made to reference either an undeclared variable, exception, procedure, or other item, or an item to which no privilege was granted or an item to which privilege was granted only through a role.
Action:
1. Check your spelling and declaration of the referenced name.
2. Verify that the declaration for the referenced item is placed correctly in the block structure.
3. If the referenced item is indeed declared but you do not have privileges to refer to that item, for security reasons, you will be notified only that the item is not declared.
4. If the referenced item is indeed declared and you believe that you have privileges to refer to that item, check the privileges; if the privileges were granted only via a role, then this is expected and documented behavior.
Stored objects (packages, procedures, functions, triggers, views) run in the security domain of the object owner with no roles enabled except PUBLIC. Again, you will be notified only that the item was not declared.
|
|
|