ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'
437130Oct 13 2005 — edited Mar 6 2009The following issues happen only on 10gR2, not on 10gR1.
I've got a very simple schema registered and mapped to table "message". No data entered, jmust an empty table.
SELECT extractValue(x.object_value, '/message/@uidMessage')FROM message x WHERE existsNode (x.object_value, '/message')=1
causes "ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'".
If I remove the variable 'x' usage, i.e.
SELECT extractValue(object_value, '/message/@uidMessage')FROM message WHERE existsNode (object_value, '/message')=1
the SELECT succeeds, returning 0 rows as expected.
(I already haved filed a tar on a related issue:
SELECT * FROM message x WHERE existsNode (x.object_value, '/message')=1
causes a ORA-07445 (core dump!))
My questions are : nothing wrong with these queries, right? And what the heck is OGC_X?
Regards,
Hugh