Re: Oracle Reports generated JSP and user parameters.

"Brian Peasland" <oracle_dba_at_nospam.peasland.net> wrote in message news:J0E8wu.IuG_at_igsrsparc2.er.usgs.gov...
> mich (at work) wrote:
>> Hi,
>>
>> I'm creating JSP pages via reports builder (10.1.2). I'm passing in a
>> number of user parameters via a parameter screen (basically HTML), and
>> want to display these params in the resulting web page. The param screen
>> calls a procedure at the db whic returns a ref cursor.
>>
>> I cant for the life of me work out how to do this. I'm sure it's a really
>> easy thing to do, but just can't get it.
>>
>> Any pointers would be much appreciated.
>>
>> Cheers,
>>
>> Michael Peel.
>
> I'm not sure that JSP's support REF CURSORS. But then I could be totally
> off base on that too. Have you looked on Technet?
>
> http://www.oracle.com/technology/sample_code/tech/java/jsps/index.html
>
>
> HTH,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown

Brian,

I have a number of JSP's with ref cursors running already. I just wanted a mechanism to pass parameters between reports rather than having to select them in each ref cursor.

Cheers,

M. Received on Thu Jun 08 2006 - 16:26:08 CEST