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

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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00357：表，视图或序列引用“ string ”在此上下文中不允许,
.原因：在不适当的上下文中找到了对数据库表，视图或序列的引用。此类引用只能出现在％TYPE和％ROWTYPE声明中的SQL语句或（不包括序列）中。一些有效的例子如下：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;,
.操作：删除或重新定位非法参考。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题