Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Restricted LOV in reports 2.5

Re: Restricted LOV in reports 2.5

From: JOC <oconnorj_at_freenet.co.uk>
Date: Tue, 14 Dec 1999 12:14:37 GMT
Message-ID: <38563479.10599127@NEWS>


On Fri, 10 Dec 1999 13:03:44 +0100, Mitja <mitja.s_at_gmx.net> wrote:

>Oracle Reports 2.5
>
>I have two user parameters with LOV defined with select statement
>and I wish to restrict LOV2 with item, that user has selected in LOV1
>
>-----------
>LOV 1 parameter: p_a select statement: (select t1.a from t1)
>-----------
>
>-----------
>LOV 2 parameter: p_b select statement: (select t2.c from t2
>where t2.x=:p_a)
>-----------
>
>I see this error: REP-0781: Bind variables are not allowed in the
>Select statement.
>
>Please help, how can I do this in reports.
>
>Thanks a lot!

We do this by creating a record group (where you can use bind variables) and then populating the LOV from the record group.

Jo


The usual - anything I say reflects on me, and not upon my current employer.


Received on Tue Dec 14 1999 - 06:14:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US