Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
How to call Procedure(IN OUT Paramentes) in Query Text of BIRT Report
MohanpPrabu
<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
micajblock
<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>