Quickly resolve Oracle Database errors with Oracle Doctor

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.

PLS-00358 Comments

No comments yet

Submit comments and questions for PLS-00358

No registration required

CAPTCHA Image New word