Re: Is there a way to code Dynamic SQL in a Forms 4.5 Trigger?
From: Mike J Cox <mike_at_kane.demon.co.uk>
Date: 1996/02/04
Message-ID: <655533278wnr_at_kane.demon.co.uk>#1/1
Date: 1996/02/04
Message-ID: <655533278wnr_at_kane.demon.co.uk>#1/1
> 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