<?xml version="1.0" encoding="UTF-8"?>
<action-sequence> 
  <title>Test SQL Execute 4</title>
  <version>1</version>
  <logging-level>DEBUG</logging-level>
  <documentation> 
    <author>Marc Batchelor</author>  
    <description>This tests the SQL Execute rule to make sure that multiple-statements work with a different multi-line separator.</description>  
    <help/>  
    <result-type>rule</result-type>  
    <icon/> 
  </documentation>

  <inputs/>

	<outputs>
		<rule-result>
			<type>list</type>
		</rule-result>
	</outputs>

  <resources/>
  
  <actions>
      <action-definition>

        <action-outputs>
          <rule-result type="list"/>
        </action-outputs>
        
        <component-name>SQLExecute</component-name>
        <action-type>rule</action-type>
      	<component-definition>
          <jndi>SampleDataAdmin</jndi>
          <continue_on_exception>true</continue_on_exception>
          <multi_statement_separator><![CDATA[~]]></multi_statement_separator>
          <query><![CDATA[
            drop table foo~
            create table foo (bar int)~
            insert into foo values (1)~
            delete from foo~
            drop table foo
          ]]></query>
        </component-definition>
      </action-definition>
  </actions> 
</action-sequence>