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

ORA-31180: DOM Type mismatch in invalid PL/SQL DOM handle

1 Answers  


ORA-03235: max # extents (string) reached in table string.string subpartition string

1 Answers  


ORA-06320: IPA: Remote maximum number of connections exceeded

1 Answers  


ORA-37008: (AWLISTALL06) number writers

1 Answers  


ORA-32139: Cannot write to the stream

1 Answers  






ORA-16639: specified instance inactive or currently unavailable

1 Answers  


CLSR-00501: Error number encountered when connecting to EVM daemon

1 Answers  


ORA-13344: an arcpolygon geometry has fewer than five coordinates

1 Answers  


NID-00127: All online files in the database must have the same checkpoint SCN

1 Answers  


ORA-09809: Unable to get user's group ID from connection

1 Answers  


PLS-01419: Subquery must have either '*' or exactly one column in its select list

1 Answers  


IMG-02011: 2FF11 - unsupported image format conversion specified

1 Answers  


Categories