forms5: dynamic where in procedure?

[Quoted] [Quoted] Im trying to do something like that in procedure program unit:

[Quoted] :misc.my_where_clause is a varchar2 that contains a valid where-clause. That where-clause is created dynamically at runtime.

BEGIN
DECLARE
  select count(*)
    into :misc.my_counter
    from my_table
    where :misc.my_where_clause;
END; This doesn't work ( I didn't expect it to). I could create a dummy-block and set its default-where programmatically. But I need this in 9 cases for nine large tables and it would lead to nine large dummy-blocks.

Annyone has a better idea?
Thanks
Gudrun Received on Tue Mar 23 1999 - 15:38:34 CET