Re: Lexical parameter in cursor

Faisal wrote:

> Dear all,
>
> We are creating a Report6 library with many queries. These queries
> differs from other queries only in one clause.
>
> We wish to pass that clause from report, so that single query fulfils
> needs in different scenarios. But when we are trying to refer a
> lexical parameter in library, it is giving error.
>
> Is there a way to use lexical parameters in library/cursor, whose
> value is passed at runtime.
>
> I will be grateful for your help.
>
> Regards

I would suggest you implement your library as a back-end package using native dynamic SQL. You can load result sets into a single table and write your report against that table.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)