How to call Procedure(IN OUT Paramentes) in Query Text of BIRT Report

<p>Hi,</p>
<p> </p>
<p>I am writing a procedure for BIRT report and I wanted to call that procedure in BIRT.C ould you please help me how to call this procedure in Query Text below is the procedure parameters.</p>
<p> </p>
<p> </p>
<p>BIRT version : 4.6.0.V2</p>
<p> </p>
<p>Procedure:-</p>
<p>

</p>
<p>Create or replace procedure BIRT_Report_TEST(</p>
<p>M_Session_id varchar,</p>
<p>m_execute_for varchar,</p>
<p>M_cursor IN OUT CR_reports)</p>
<p> </p>
<p>AS</p>
<p>

</p>
<p> </p>
<p>Thanks & Regards,</p>
<p>Mohan</p>
<p> </p>

Find more posts tagged with

Comments

<p>You use Oracle JDBC syntax - <a data-ipb='nomediaparse' href='https://docs.oracle.com/cd/E17952_01/connector-j-en/connector-j-usagenotes-statements-callable.html'>https://docs.oracle.com/cd/E17952_01/connector-j-en/connector-j-usagenotes-statements-callable.html</a></p>
<p> </p>
<p>In your case:</p>
<pre class="_prettyXprint">
{call BIRT_Report_TEST(?, ?)}</pre>