I'm very much interested to answer questions on Stack Overflow but everytime I try to answer, the answer can not be posted because of the SQL.
It simply returns "An Error occurred submitting the answer/edit", there is no further explanation.
I used proper quotes and interestingly enough if I upload code up to the
where clause it works perfectly, but if I include the
where clause posting the answer will fail.
This is the code that is problematic:
col column_name FOR a30 SELECT d.owner, d.table_name, c.constraint_name, d.column_name, c.constraint_type FROM dba_constraints c, dba_cons_columns d WHERE c.table_name = '&TABLE_NAME' AND c.owner = '&SCHEMA_NAME' AND c.constraint_name = d.constraint_name