-
PLS-00801: internal error [phdcsql_canonical_sql]
Hi again
Using a query like this:
Code:
INSERT INTO OM_DB.CDRS_VALIDOS_TMP (
SELECT
FROM (
SELECT
FROM (
SELECT
FROM (
.....
)
)
FULL OUTER JOIN
(
SELECT ....
)
)
)
I receive this errors:
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|