PLS-00357: Table,View Or Sequence reference 'string' not
allowed in this context

Answers were Sorted based on User's Feedback



PLS-00357: Table,View Or Sequence reference 'string' not allowed in this context..

Answer / ramnath

i also have the same problemm,,
Wat to need immediate answer

Is This Answer Correct ?    0 Yes 0 No

PLS-00357: Table,View Or Sequence reference 'string' not allowed in this context..

Answer / guest

Cause: A reference to database table, view, or sequence was
found in an inappropriate context. Such references can
appear only in SQL statements or (excluding sequences) in
%TYPE and %ROWTYPE declarations. Some valid examples follow:
SELECT ename, emp.deptno, dname INTO my_ename, my_deptno,
my_dept .FROM emp, dept WHERE emp.deptno = dept.deptno;
DECLARE last_name emp.ename%TYPE; dept_rec dept%ROWTYPE;

Action: Remove or relocate the illegal reference.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00233: namespace prefixes starting with "xml" are reserved

1 Answers  


NNO-00615: disabling DEFAULT-FORWARDERS-ONLY mode

1 Answers  


ORA-00059: maximum number of DB_FILES exceeded

2 Answers  


ORA-07345: The datafile name must not contain the string '..'.

1 Answers  


PLS-00712: illegal option for subprogram string

1 Answers  






QSM-02120: compatibility mode must be 9.0 or higher

1 Answers  


EXP-00076: multiple devices specified for tape output

1 Answers  


SQL*Loader-00131: Invalid multithreading option

1 Answers  


ORA-12592: TNS:bad packet

1 Answers   BoCom,


SQL-02157: Source or destination lob is invalid

1 Answers  


ORA-32027: There is no string column with the matching type in string.string.

1 Answers  


ORA-09353: Windows 32-bit Two-Task driver unable to open event semaphore

1 Answers  


Categories