PLS Database Error Messages

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

oracle

PLS-00357: Table,View Or Sequence reference 'string' not allowed in this context
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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/