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; } } }

Assign Stored Procedure Output Parameter to Global Variable

dchillman

I have a dataset created from a stored procedure that has an output parameter. I would like to take the value of the output parameter and assign it to a global variable for use in later sections of the report. Is that possible, and if so, can you tell me how? thanks

Find more posts tagged with

Comments

mcremer

<blockquote class='ipsBlockquote' data-author="'dchillman'" data-cid="77340" data-time="1305924375" data-date="20 May 2011 - 01:46 PM">
I have a dataset created from a stored procedure that has an output parameter. I would like to take the value of the output parameter and assign it to a global variable for use in later sections of the report. Is that possible, and if so, can you tell me how? thanks </blockquote>
 
Hi what you want is quite hard. What I would do is make a data set that gives you 1 reslult (read my colleuge's blog about that: <a class='bbc_url' href='http://enterprisesmartapps.wordpress.com/2011/02/24/oracle-stored-procedure-data-set-in-birt/'>http://enterprisesmartapps.wordpress.com/2011/02/24/oracle-stored-procedure-data-set-in-birt/</a>) 
 
Then I would just access the dataset on the given time or join with a nother data set if you need it in to do calculations.