This discussion is archived
11 Replies Latest reply: Mar 6, 2009 9:38 AM by MarcoGralike RSS

ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'

437130 Newbie
Currently Being Moderated
The 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