Re: Deferrable constraints in stored procedures

Steve Nyberg wrote:

> Is there a way to add SQL like the following, which works fine in SQL
> Plus and Toad, to a stored procedure? This code is used for cascading
> updates of PK/FK fields in multiple tables. My guess is the SET
> CONSTRAINTS line is not valid in PL/SQL, even when I've added a SET
> TRANSACTION READ WRITE before it. Is there a workaround to do this in
> a procedure? Thanks in advance,
>
> Steve
>
> SET CONSTRAINTS ALL DEFERRED;
> update route set routeareaid=0 where routenbr=888;
> update subroute set routeareaid=0 where routenbr=888;
> COMMIT;
I have used syntax similar to yours in procedures. Did you try it?

SET is perfectly valid in PL/SQL.

Daniel A. Morgan Received on Thu Jun 07 2001 - 00:55:14 CDT