PLS-00327: "string" is not in SQL scope here



PLS-00327: "string" is not in SQL scope here..

Answer / guest

Cause: In a SQL statement, a reference was made to an
out-of-scope database object. The referenced object might be
misspelled, or the reference might be mixed, as in the
following example: CURSOR c1 IS SELECT dept.dname FROM emp;

Action: Check the spelling of all database objects in the
SQL statement, and make sure all references are to objects
within the current scope.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

1 Answers   ABC,


SQL*Loader-00423: element count is greater than maximum allowed for the column

1 Answers  


NNO-00084: domain "string" is not in the authoritative domain list

1 Answers  


ORA-16090: archive log to be replaced not created by managed standby process

1 Answers  


ORA-16529: bad sender id

1 Answers  


CLSR-01006: Unable to process instance shutdown

1 Answers  


ORA-23450: flavor already contains object "string"."string"

1 Answers  


ORA-15010: name is already used by an existing ASM disk

1 Answers  


ORA-19734: wrong creation SCN - control file expects converted plugged-in datafile

1 Answers  


ORA-02149: Specified partition does not exist

1 Answers  


ORA-01228: SET DATABASE option required to install seed database

1 Answers  


IMP-00057: Warning: Dump file may not contain data of all partitions of this table

1 Answers  


Categories