Re: dynamic UPDATE statement
From: Michael Taylor <mtaylor_at_ptdprolog.net>
Date: 1997/03/04
Message-ID: <01bc2836$06471cc0$4208bacc_at_mctaylor>#1/1
Date: 1997/03/04
Message-ID: <01bc2836$06471cc0$4208bacc_at_mctaylor>#1/1
I believe there is a built-in package called FORMS_DDL or somesuch that will take any SQL statement and dynamically execute it. If you require more precise control than a single statement, you will have to resort to the DBMS_SQL package which as of release 1.3 still has to run on the server side.
Regards,
Mike
fs_at_tis.be wrote in article <331b6fc7.28635423_at_news.innet.be>...
> Does anyone know how to write a dynamic UPDATE statement in Oracle
> Forms 4.5. We want to create the WHERE-clause dynamically at runtime.
>
> Thanks for all suggestions.
>
> Carl Van de Casteele
> Koen Schaubroeck
>
Received on Tue Mar 04 1997 - 00:00:00 CET