The SqlBatchStmt creates an array of sql stmts with runtime values to be executed by a DbBatchStmt parent. This class is similar to a SqlStmt which only returns a single stmt.

In the next hypothetical example the userid parameter returns a String[] with one element and the option parameter returns a String[] with multiple elemements. A separate sqlstmt will be created for each option value. The userid will be the same in all the stmts but a different option value will be inserted into each one.

<dxp:SqlBatchStmt>
   <dxp:Cp name="sql">insert into preference where userid=? and option='?'</dxp:Cp>
   <dxp:SqlBatchParam name="userid" type="NUMBER" require="true"/>
   <dxp:SqlBatchParam name="option" type="CHAR" require="true"/>
</dxp:SqlBatchStmt>

Return to Index

Note: We have tried to test all of the code examples but they may contain errors. Any questions, comments, suggestions, or problems should be sent to info@plands.com.