Home » Developer & Programmer » Reports & Discoverer » use lexical paramer in select statement
use lexical paramer in select statement [message #88348] Mon, 15 July 2002 18:29 Go to next message
Messages: 68
Registered: April 2001

I have a report like below:

select d.dname, &par1 mgrSal, &par2 empSal from emp e, dept d where d.deptno=e.deptno
and d.deptno = :dno;

Here the &par1 and &par2 are calling a function like:
:par1 := ' f(:dno, :job)';
in the after parameter form. the function returns a number ( something like count(*) or max(sal) ).

Now the reports server (6i) generats error message:
inlalid column or miss expression.

What is the right way for this kind of report? Please help me.

Any help is greatly appreciated.
Re: use lexical paramer in select statement [message #88736 is a reply to message #88348] Thu, 27 February 2003 13:40 Go to previous message
Messages: 13
Registered: February 2003
Junior Member

call that Stored Procedure / Function from After Parameter form trigger with that lexical Parameters take the return value print it on the report.

Previous Topic: Re: How to put header in first page only
Next Topic: print page number at every page of report
Goto Forum:

Current Time: Sun Jan 16 21:25:15 CST 2022