Re: Is there a way to code Dynamic SQL in a Forms 4.5 Trigger?

Mike J Cox wrote:
>
> > In PRO*C, there is a construct "EXEC SQL PREPARE" in which you can
> > dynamically put together a SQL statement at runtime. I would like to
 do
> > the same thing in a Forms 4.5 trigger
>
> Theres a package that comes with 7.1 onwards (may be 7.1.3 onwards ?)
> called dbms_sql, it provides all the same exec sql etc stuff as pro*c,
> if are running under windows theres a an addendum in the 7.1 server
> manual, one of the chapters is all about dynamic sql, everything you
> ever wanted to know ......
>
> Mike

You can also use the Forms builtin FORMS_DDL. Although there you can't use cursors.

 J. Brunner

 Robert Bosch GmbH, Dep. QI/LBS2-Rt
 D-72762 Reutlingen, Germany