Automatic passing of parameter to SP Oracle possible?

[beltmanjr]

I created the most basic stored procedure in oracle and a report based upon this stored procedure and a table.

Both have userId as a field and in the stored procedure it is a parameter too.

Now I wish to automatically pass an userId to the sp parameter based on the records selected from the table.

Is this possible?

In case you are wondering why? Well this is a test with a simple table and sp, but in reality I work with a couple of tables and a gigantic view. The records the view collects could be reduced to only 1 per record selected in the table if only I could pass a value into the WHERE clause of the view. Hence I thought of using a stored procedure

Due to having to use range parameters on the tables I cant add all into a command. And due to having to export to csv subreports are off limit.

 

[FredHelm]

Hi,

Check out the following kbase article which will lead you to a white paper on how to use Oracle Stored Procedures.

http://technicalsupport.businessobj...iceId=&dialogID=16126945&stateId=1 0 16124711

Fred