Re: ORA-00604: Help please!

From: Hakan <nvcinc_at_ibm.net>
Date: Fri, 05 Feb 1999 18:29:05 -0500
Message-ID: <36BB7EC1.5DE59FE2@ibm.net>

Try this:

FORMS_DDL('BEGIN delete from t1 where reference in (''0010'', ''0001'', ''0210'');' ||

                                    || 'delete from t2 where reference in

(''0010'', ''0001'', ''0210''); COMMIT; END;'); Hakan

Pilsbury wrote:

> Hi everyone,
>
> I'm trying to delete from a number of tables in one go, for example
>
> delete from t1 where reference in ('0010', '0001', '0210');
> delete from t2 where reference in ('0010', '0001', '0210');
> etc...
>
> I am using Forms 4.5 and keep getting ORA-00604 exception. Does anyone
> have any advice on getting round this? Any help would be much appreciated.
> TIA
>
> Nick
Received on Fri Feb 05 1999 - 17:29:05 CST