Xref: alice comp.databases.oracle.tools:23904
Path: alice!news-feed.fnsi.net!cyclone.i1.net!newsfeed.enteract.com!korova.insync.net!solomon.io.com!news-feeds.jump.net!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: Lars Schouw <lars.schouw@zkb.ch>
Newsgroups: comp.databases.oracle.tools
Subject: Re: Oracle report 3.0 problem
Date: Mon, 26 Apr 1999 16:30:21 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 47
Message-ID: <7g24at$kve$1@nnrp1.dejanews.com>
References: <7eav1s$4vl$1@nnrp1.dejanews.com> <37092455.C40935FF@computer.org>
To: brenogomes@computer.org
X-Article-Creation-Date: Mon Apr 26 16:30:21 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; TUCOWS)
X-Http-Proxy: 1.0 x4.dejanews.com:80 (Squid/1.1.22) for client 194.209.136.6

Hi.

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

Lars
In article <37092455.C40935FF@computer.org>,
  brenogomes@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@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@zkb.ch

Regards,
Lars

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own