Re: forms5: dynamic where in procedure?

The only method other than using your dummy blocks and setting the where clause at run time is to use the DMBS_SQL dynamic sql package. Unfortunately, it is not the easiest thing to use, and some calls from Forms do not work -- you have to create a stored procedure to call DBMS_SQL, and call the procedure from your form.

Steve Cosner

In article <36F7A76A.4C2EA8E7_at_itu.fzk.de>, Gudrun Janssen <janssen_at_itu.fzk.de> wrote:
>Hello,
>
>Im trying to do something like that in procedure program unit:
>
>: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 - 19:04:28 CET