Hi,

I'm trying to call a stored procedure in a XML driver but i don't know
where to put the script.

The document says that i have to append this code:

<JDBC:STATEMENT>
<JDBC:CALL-PROCEDURE JDBC:NAME=\"INDIRECT.ALTA_USUARIO\">
<!-- EMPTY VALUE ELEMENT = PASS EMPTY STRING -->
<JDBC:PARAM>
<JDBC:VALUE/>
</JDBC:PARAM>
</JDBC:CALL-PROCEDURE>
</JDBC:STATEMENT>

But it doesn't say where, so i put it in a rule on the output
transformation policy in the subscriber channel. When i do that, the
answer is:


CODE(-9124) ERROR IN
VND.NDS.STREAM://IDMTREE/ARCOSDORADOS/SERVICIOS/DRVSET/WAREHOUSE4/CALLPROCEDUREINSERT#XMLDATA:15
: ELEMENT 'JDBC:STATEMENT' NOT ALLOWED IN 'ACTIONS'.


Where do i have to put the code to recognize this element?


Thank you.


--
gtejo
------------------------------------------------------------------------
gtejo's Profile: https://forums.netiq.com/member.php?userid=1220
View this thread: https://forums.netiq.com/showthread.php?t=57792