Re: Oracle report 3.0 problem

From: Lars Schouw <lars.schouw_at_zkb.ch>
Date: Mon, 26 Apr 1999 16:30:33 GMT
Message-ID: <7g24b9$kvu$1_at_nnrp1.dejanews.com>


Hi.

How do I pass parameters from a cgi call into my Oracle Report and use it there?

Lars
In article <37092455.C40935FF_at_computer.org>,   brenogomes_at_computer.org wrote:
> Try to pass parameters from Forms like:
>
> sql_stat := 'WHERE ID = ' || :CALIBRATOR.ID ||' ORDER BY
> CALIBRATOR.DESCRIPTION ASC';
> ADD_PARAMETER(param_list_id, 'WHERE_CLAUSE', TEXT_PARAMETER, sql_stat);
> RUN_PRODUCT(REPORTS, 'calibrat', ASYNCHRONOUS, RUNTIME, FILESYSTEM,
> param_list_id, NULL);
>
> If you need more details fell free to contact me.
>
> amitabh12_at_my-dejanews.com wrote:
>
> > Hello, I am using Oracle Reports 3.x. The situation is that I have no
query
> > build. I am just using a formula column. I want to create two parameters.
> > First one is called year (select year from this_year); Second one is where
> > the problem is.. When I do (select ssno from emp_data where emp_year
= :year)
> > oracle reports return the following error..
> >
> > REP-0781 :Bind variables are not allowed in Select Statement.
> >
> > Please Help.
> >
> > Thanks
> > Munish
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>

--
Please reply in email also to lars.schouw_at_zkb.ch

Regards,
Lars

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    
Received on Mon Apr 26 1999 - 18:30:33 CEST

Original text of this message