Toad World® Forums

Execute

SEE ATTACHMENT

acip.vcf (298 Bytes)

image001.jpeg

image001.jpeg

image003.gif

image005.gif


acip.vcf (328 Bytes)

Just for fun – does it work if execute and function are on the same line
(i.e. not all by itself) ??? That would be a bug – but worth double
checking to see if that’s it …
image001.jpeg

Just for fun – does it work if execute and function are on the same line
(i.e. not all by itself) ??? That would be a bug – but worth double
checking to see if that’s it …
image004.jpeg

Just for fun – does it work if execute and function are on the same line
(i.e. not all by itself) ??? That would be a bug – but worth double
checking to see if that’s it …
image003.gif

Just for fun – does it work if execute and function are on the same line
(i.e. not all by itself) ??? That would be a bug – but worth double
checking to see if that’s it …

Just for fun – does it work if execute and function are on the same line
(i.e. not all by itself) ??? That would be a bug – but worth double
checking to see if that’s it …
image005.gif

Just for fun – does it work if execute and function are on the same line
(i.e. not all by itself) ??? That would be a bug – but worth double
checking to see if that’s it …
image002.jpeg

Will it run via SQL*Plus?
image003.gif

Will it run via SQL*Plus?
image002.jpeg

Will it run via SQL*Plus?
image005.gif

Will it run via SQL*Plus?
image004.jpeg

Will it run via SQL*Plus?
image001.jpeg

Will it run via SQL*Plus?

Also – where is your cursor – it appears to be on begin parenthesis.
There are some execute and execute as script differences that have been
described on this list dozens of times – so maybe Greg can say them once
again J

Also – where is your cursor – it appears to be on begin parenthesis.
There are some execute and execute as script differences that have been
described on this list dozens of times – so maybe Greg can say them once
again J
image002.jpeg

Also – where is your cursor – it appears to be on begin parenthesis.
There are some execute and execute as script differences that have been
described on this list dozens of times – so maybe Greg can say them once
again J
image001.jpeg

Also – where is your cursor – it appears to be on begin parenthesis.
There are some execute and execute as script differences that have been
described on this list dozens of times – so maybe Greg can say them once
again J
image003.gif

Also – where is your cursor – it appears to be on begin parenthesis.
There are some execute and execute as script differences that have been
described on this list dozens of times – so maybe Greg can say them once
again J
image005.gif

Also – where is your cursor – it appears to be on begin parenthesis.
There are some execute and execute as script differences that have been
described on this list dozens of times – so maybe Greg can say them once
again J
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
image005.gif