Re: "execute immediate" executes too early
Date: Thu, 29 Jun 2006 05:51:12 -0400
Message-ID: <5dOdnUGKrZsJPz7ZnZ2dnUVZ_tadnZ2d_at_comcast.com>
"olistef" <olistef_at_olistef.com> wrote in message
news:1151574030.722094.120400_at_m73g2000cwd.googlegroups.com...
: 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
:
that's not possible -- depending of course on what your procedure is doing and when you're generating the 'timestamp'
run with a debugger and you'll see the sequential execution also check your 'timestamp' logic (are you using a timestamp datatype?)
++ mcs Received on Thu Jun 29 2006 - 11:51:12 CEST