Restricted LOV in reports 2.5

From: Mitja <mitja.s_at_gmx.net>
Date: Fri, 10 Dec 1999 13:03:44 +0100
Message-ID: <3850EC20.773CF69E@gmx.net>

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! Received on Fri Dec 10 1999 - 06:03:44 CST