MQSeries.net :: View topic

broker_new · Posted: Fri Apr 25, 2014 6:41 am Post subject: Oracle XMLType as IN Parameter

Hi Guys,

We have a stored procedure that is defined in Oracle where one of the IN parameter is defined as XMLType.

Here is the signature of the stored procedure.

CREATE OR REPLACE PROCEDURE "INSERT_EMPLOYEE_DATA"(
ip_emp_details IN XMLTYPE
)
IS
BEGIN
END INSERT_EMPLOYEE_DATA;

/

I tried passing the XML object as CHAR from compute node..

(0x03000000:NameValue):Text = 'The procedure is unknown to the database and no definition could be found.' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'LOCAL_DB.ORCL.INSERT_EMPLOYEE_DATA' (CHARACTER)

make absolutely sense....what should be the mapping from ESQL to Oracle for XMLType?

_________________
IBM ->Let's build a smarter planet