Re: dynamic UPDATE statement
From: Chris Halioris <halioris_chris_nonlilly_at_lilly.com>
Date: 1997/03/06
Message-ID: <331EFA93.2090_at_lilly.com>#1/1
Date: 1997/03/06
Message-ID: <331EFA93.2090_at_lilly.com>#1/1
fs_at_tis.be wrote:
>
> 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.
Use DBMS_SQL. Since you cannot call DBMS_SQL directly from Forms 4.5 you will have to create an intermediate stored/packaged procedure that you call from Forms that will make use of DBMS_SQL.
Chris Halioris
Tactics, Inc.
hali_at_tacticsus.com
Received on Thu Mar 06 1997 - 00:00:00 CET