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.