Re: dynamic UPDATE statement
From: Rickster <richu_at_spacelab.net>
Date: 1997/03/06
Message-ID: <01bc2a6e$9fb464a0$ec832ace_at_default>#1/1
Date: 1997/03/06
Message-ID: <01bc2a6e$9fb464a0$ec832ace_at_default>#1/1
Tim Dickson <timd_at_mail.enterprise.net> wrote in article
<01bc2a54$b6ac5ce0$27c548c2_at_timd>...
> Carl,
> Use the PL/SQL V2 package dbms_sql.
> However you must call this from a stored procedure or function as Forms
4.5
> does not support PL/SQL V2.
> 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
Try building the entire SQL update string dynamically and issue it via FORMS_DDL( ). This is esentially dynamic.
RIc Received on Thu Mar 06 1997 - 00:00:00 CET