Re: "execute immediate" executes too early
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 29 Jun 2006 08:33:37 -0700
Message-ID: <1151595224.358519_at_bubbleator.drizzle.com>
Date: Thu, 29 Jun 2006 08:33:37 -0700
Message-ID: <1151595224.358519_at_bubbleator.drizzle.com>
olistef wrote:
> Hi
> I frequently run a PL/SQL procedure which includes several
>
> "execute immediate 'begin <procedure name>; end;' "
>
> statements in a row. The executions are logged including timestamps. I
> have not recognized a pattern yet, but sometimes the next statement is
> executed before the previous statement has finished execution.
> Is this a normal PL/SQL behaviour? Can I do something to prevent this
> from happening?
>
> Thanks
In addition to the comments of others it seems somewhere between pointless and a waste of resources to be using NDS to run procs. Why? And in what version of Oracle?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Jun 29 2006 - 17:33:37 CEST