nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calling a procedure before generating a report

mmarto

Hi guys,

Can someone give me an advise on how to execute an oracle stored procedure prior to generating a report in BIRT.
My procedure doesn't return any cursor. And I want to run it before the select I have in the dataset.
What is the best way to achive this?

Thanx

Find more posts tagged with

Comments

_Petr

<blockquote class='ipsBlockquote' data-author="'mmarto'" data-cid="68526" data-time="1284737385" data-date="17 September 2010 - 08:29 AM">
Hi guys, 
 
Can someone give me an advise on how to execute an oracle stored procedure prior to generating a report in BIRT. 
My procedure doesn't return any cursor. And I want to run it before the select I have in the dataset. 
What is the best way to achive this? 
 
Thanx </blockquote>
Hi mmarto. 
You can execute an oracle store procedure through script - beforeFactory. 
<pre class='_prettyXprint _lang-auto _linenums:0'>
procedure = new Packages.com.oracle.Procedure();
procedire.init();
</pre>
where com.oracle.Procedire() - this Java class 
init() - method executing oracle procedure.