Re: Oracle report 3.0 problem
Date: Mon, 05 Apr 1999 22:00:05 +0100
Message-ID: <37092455.C40935FF_at_computer.org>
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
Received on Mon Apr 05 1999 - 23:00:05 CEST