Execute

10.6 has a bug with F9 when using "execute" instead of "exec" so you'll want to
use "exec" instead. This is fixed in Toad 11.

are on the same line (i.e. not all by itself)

Looks like this may be the trick and also the way SQL*Plus behaves at least with
this example " exec dbms_output.put_line ( 'a' ); "

That would be a bug

Not sure it would be a bug even if it's a change from previous versions. Looking
at the navigator indicates that the parser also requires it on one line so it
appears to support the syntax as setup by Oracle unless you see something I do
not. I tried in SQL*Plus 11.2.

Michael
image001.jpeg

10.6 has a bug with F9 when using "execute" instead of "exec" so you'll want to
use "exec" instead. This is fixed in Toad 11.

are on the same line (i.e. not all by itself)

Looks like this may be the trick and also the way SQL*Plus behaves at least with
this example " exec dbms_output.put_line ( 'a' ); "

That would be a bug

Not sure it would be a bug even if it's a change from previous versions. Looking
at the navigator indicates that the parser also requires it on one line so it
appears to support the syntax as setup by Oracle unless you see something I do
not. I tried in SQL*Plus 11.2.

Michael
image004.jpeg

10.6 has a bug with F9 when using "execute" instead of "exec" so you'll want to
use "exec" instead. This is fixed in Toad 11.

are on the same line (i.e. not all by itself)

Looks like this may be the trick and also the way SQL*Plus behaves at least with
this example " exec dbms_output.put_line ( 'a' ); "

That would be a bug

Not sure it would be a bug even if it's a change from previous versions. Looking
at the navigator indicates that the parser also requires it on one line so it
appears to support the syntax as setup by Oracle unless you see something I do
not. I tried in SQL*Plus 11.2.

Michael
image003.gif

10.6 has a bug with F9 when using "execute" instead of "exec" so you'll want to
use "exec" instead. This is fixed in Toad 11.

are on the same line (i.e. not all by itself)

Looks like this may be the trick and also the way SQL*Plus behaves at least with
this example " exec dbms_output.put_line ( 'a' ); "

That would be a bug

Not sure it would be a bug even if it's a change from previous versions. Looking
at the navigator indicates that the parser also requires it on one line so it
appears to support the syntax as setup by Oracle unless you see something I do
not. I tried in SQL*Plus 11.2.

Michael

10.6 has a bug with F9 when using "execute" instead of "exec" so you'll want to
use "exec" instead. This is fixed in Toad 11.

are on the same line (i.e. not all by itself)

Looks like this may be the trick and also the way SQL*Plus behaves at least with
this example " exec dbms_output.put_line ( 'a' ); "

That would be a bug

Not sure it would be a bug even if it's a change from previous versions. Looking
at the navigator indicates that the parser also requires it on one line so it
appears to support the syntax as setup by Oracle unless you see something I do
not. I tried in SQL*Plus 11.2.

Michael
image002.jpeg

SEE ATTACHMENT
acip.vcf (328 Bytes)

SEE ATTACHMENT
att1.dat (140 KB)