Re: How to implement dynamic SQL in Forms?

Hi Big John,

                  What you can do is store the :system.last_query is a
global.variable or a parameter, then
                     Later on build a select statement  1. Using  DBMS_SQL  or
                                                                       2. Using
User exit(PRO*C), Dynamic statement(method 3 of Pro*c) or
                                                                        3.

Regards
Sandy

Big John wrote:

> Hi,
>
> I would like to reuse the :system.last_query as a sub_query in a forms
> procedure, so that I can count some number like the followings:
> select count(col1) from table_a
> where exists (select col1 from table_b where ......)
> and the :system.last_query is exactly the sub-query statement. But forms
> does not accept the syntax if I replace the sub-query to :system.last_query.
> So what can I do?
>
> Best Regards,
> John
Received on Wed Dec 23 1998 - 10:25:11 CET