11 Replies Latest reply on Mar 6, 2009 5:38 PM by Marco Gralike

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

    437130
      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