Re: Using dynamic SQL in Developer 2000

You can also use the forms_ddl package. All you do is create the query string, say

qry := 'select xyz from table where xyz=''asdf''',

and then pass it to forms_ddl:

forms_ddl(qry);

Hope this helps,

Tom Mettling
W.T. Chen & Company, Inc.
mettlingt_at_wtchen.com

QuadTwin wrote:

> Maoz Mussel wrote:
> >
> > Hi,
> >
> > I would like to run dynamic SQL statement in Developer 2000.
> > In particular, I would like to run the following query:
> > SELECT count (*) FROM table_name WHERE|| where_var
> >
> > Where 'where_var' will be a variable including the where statement.
> > I know I should be doing it using DBMS_SQL (is there another way
 ???),
> > but:
> > 1) Current version of D2k doesn't support pl/sql 2 which I need to
> > run such a query.
> > 2) I try to run it directly from the server, and couldn't found the
> > correct syntax.
> >
> > If you have an example to what I need, and/or can advice me some
> > more on this subject, please reply.
> >
> > Thanks in advance,
> > Maoz
> > (mmussel_at_iil.intel.com)
>
> The simplest way to dynamically construct a SELECT statement is
> via FORMS record groups. There are a number of builtins but the one
> I use the most is CREATE_GROUP_FROM_QUERY.
>
> Al Lawson
> Interactive Group, Inc.
> www.interactive-group.com
> lawsona_at_interactive-group.com
Received on Fri Jun 13 1997 - 00:00:00 CEST