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

PLS-00621: at least one operand in the COALESCE expression must not be NULL

1 Answers  


NZE-28817: PL/SQL function returned an error.

1 Answers  


ORA-25192: invalid option for an index-organized table

1 Answers  


QSM-02086: mv uses the MIN or MAX aggregate functions

1 Answers  


ORA-30039: Cannot drop the undo tablespace

1 Answers  






AMD-00152: Workspace "string" is not currently open.

1 Answers  


DRG-11515: not enough text key values

1 Answers  


ORA-01779: cannot modify a column which maps to a non key-preserved table

1 Answers  


RMAN-10032: unhandled exception during execution of job step number: string

1 Answers  


ORA-13265: geometry identifier column string in table string is not of type NUMBER

1 Answers  


ORA-26091: requested direct path operation not supported

1 Answers  


ORA-00070: command string is not valid

1 Answers  


Categories