Category Archives: SQL/PLSQL

Debugging "ORA-06550 Duplicate column name" error

Just trying to modify our blog user table, to fit the requirements for guest users, who could just publish articles on apexninjas.com and don't have access to all the tabs… So, added a new column and suddenly the "Create user" page gives me a "ORA-06550 Duplicate column name" error on submit (ORA-06550: line 1, column 139: PL/SQL: ORA-00957: duplicate column name ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored).

How to debug this error. Execute the following query:

Continue reading