PLS-00358 column "string" exists in more than one table; use qualifier

Translate this page

Oracle Database Error PLS-00358

PLS-00358 column "string" exists in more than one table; use qualifier

Cause

The statement is ambiguous because it specifies two or more tables having the same column name. For example, the following statement is ambiguous because deptno is a column in both tables: SELECT deptno, loc INTO my_deptno, my_loc FROM emp, dept;

Action

Precede the column name with the table name (as in emp.deptno) so that the column reference is unambiguous.

User Posts for PLS-00358

Be the first to post a message...

Post your own questions, answers and tips for PLS-00358

No registration required

CAPTCHA Image New word