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>


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.org
Received on Thu Jun 29 2006 - 17:33:37 CEST

Original text of this message