Oracle Error PLS-00358: column ‘string’ exists in more than one table; use qualifier

Oracle Error Message

PLS-00358: column ‘string’ exists in more than one table; use qualifier

Reason for the Error

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;

Solution

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