title: Execution of Oracle Procedure prior to Source Qualifier that must use the same Oracle session
body: <p>I have a security procedure that has to be called just before a select from source table. Without this procedure no rows are returned.</p>
  
  <p>The problem is that I have checked several ways to call this procedure just before Source Qualifier:</p>
  
  <ul>
  <li>Pre-sql into the <code>Source Qualifier</code> As a Stored procedure </li>
  <li>Pre-load source</li>
  <li>Put several sql sentences in the sql query propertie in <code>Source Qualifier</code> (added 2014-11-08)</li>
  </ul>
  
  <p>Always seems that Powercenter opens a new oracle connection, where security procedure takes no effect.</p>
  
  <p>What could be the correct way to put both process together and use the same Oracle session?</p>
  
  <p>Note added 2014-11-08:</p>
  
  <p>I have tried also to put 2 sentences in the SQL Query of the Source Qualifier:</p>
  
  <pre><code>call procedure('param'); 
  SELECT field1, field2, field.... from VI_ETL...; 
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/KrQNA.png" alt="enter image description here"></p>
  
  <p>and I get error ORA-24333 Zero Interaction Count, perharps because first item is not a SELECT statement that returns rows? </p>