PLS-00801: internal error [phdcsql_canonical_sql]
Using a query like this:
I receive this errors:
INSERT INTO OM_DB.CDRS_VALIDOS_TMP (
FULL OUTER JOIN
ORA-06550: line 0, column 0:
PLS-00801: internal error phdcsql_canonicalize_sql:state, Batch 1 Line 1 Col 1
Now, trust me, all the SELECT statement its ok, because i probe just that part and its working, but when i try to insert that set into the OM_DB.CDRS_VALIDOS_TMP table it doesnt work, i hear something about a bug on this version, thats my only clue, any idea?
This are the oracle settings:
"Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi"
"PL/SQL Release 10.2.0.3.0 - Production"
"CORE 10.2.0.3.0 Production"
"TNS for Solaris: Version 10.2.0.3.0 - Production"
"NLSRTL Version 10.2.0.3.0 - Production"
Thanks in advanced.