title: Why stored procedure stage in DataStage not working properly?
body: <p>I need to use the stored procedure stage.</p>
  
  <p>Currently I'm making just for an example for how to use it right.</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE "STG"."TRUNC_TEST"
  AS
  BEGIN
      execute immediate 'truncate table TESTSP';
  END;
  </code></pre>
  
  <p>That's my example of simple stored procedure.</p>
  
  <p>My job design probably seen like this</p>
  
  <pre><code>Oracle Connector 1=&gt;Transformer=&gt;Oracle Connector 2=&gt;Stored Procedure Stage
  </code></pre>
  
  <p>Oracle Connector 1 do Select, Oracle Connector 2 do Insert to TESTSP</p>
  
  <p>My settings in the stored procedure stage</p>
  
  <p>General : I've already put all the credential , with Transaction ISO as None</p>
  
  <p>Syntax</p>
  
  <pre><code>Procedure Name :  TRUNC_TEST
  Procedure Type : Transform (i've also tried to change it to Target)
  Database Procedure Type : Stored Procedure
  Generate procedure call (checked)
  </code></pre>
  
  <p>Parameters</p>
  
  <pre><code>Empty
  </code></pre>
  
  <p>Error Codes</p>
  
  <pre><code>Empty
  </code></pre>
  
  <p>NLS Map</p>
  
  <pre><code>Project Default UTF-8
  </code></pre>
  
  <p>Advanced</p>
  
  <pre><code>Execution mode :Default(Sequential)
  Combinability : Default
  Configuration file : default
  </code></pre>
  
  <p>In the Input tabs</p>
  
  <p>General</p>
  
  <pre><code>Execute Procedure for each row (checked)
  Transaction size : 0
  </code></pre>
  
  <p>Partitioning</p>
  
  <pre><code>Collector type Auto
  </code></pre>
  
  <p>Columns</p>
  
  <pre><code>Just brought all the columns from Oracle connector 2
  </code></pre>
  
  <p>Advanced</p>
  
  <pre><code>Default
  </code></pre>
  
  <p>The job showing green line and success, but the SP isn't working. It should've been truncate the TESTSP table, but when I do a <code>select *</code>, the data is still there.</p>
  
  <p>Maybe my stored procedure is wrong since I'm still learning how to make it? Or maybe there is something wrong with my 'Settings' in the stored procedure stage?</p>