We want to use XMLType in a package.
Does DOA (and the package wizard) supports XMLType ?

The wizard wrap XMLType to string.
I have the following error when i use XMLType in a function of my package :

ORA-06550: line 2, column 3:
PLS-00306: wrong number or types of arguments in call to 'P_TEST_XMLTYPE'

Jean-Pierre

No, XMLTYPE cannot be used directly. It can only be used indirectly through its getclobval() method, which returns a CLOB with the XML text.

------------------
Marco Kalter
Allround Automations