RE: Toad v11 - execute snippet at cursor doesn't like /

It might be that your proc has no statements and thus confuses things:


,what => 'BEGIN my_proc; END;'
Should maybe be


,what => 'BEGIN my_proc; NULL; END;'


From: [email protected] [mailto:[email protected]] On Behalf Of Boneist
Sent: Friday, October 14, 2011 5:27 AM
To: [email protected]
Subject: [toad] Toad v11 - execute snippet at cursor doesn't like /



Message from: Boneist


In Toad v10.6, the following would run quite happily when executed via "Execute SQL snippet at cursor (Ctrl+Enter)":

DECLARE
X NUMBER;

BEGIN

SYS.DBMS_JOB.SUBMIT
( job => X

,what => 'BEGIN my_proc; END;'

,next_date => to_date('13/10/2011 10:48:48','dd/mm/yyyy hh24:mi:ss')

,interval => 'trunc(sysdate+1) + 5/24'

,no_parse => FALSE

);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));

COMMIT;

END;

/


However, when I run the same thing in Toad v11 and execute the snippet, I get the following error:

[Error] Execution (14: 1): ORA-06550: line 14, column 1:
PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.


Was this deliberately changed to not accept the '/' on the end of the pl/sql block? Could it be changed/fixed so that it works with and without the '/' please?

_______________________________________

Historical Messages


Author: Boneist
Date: Fri Oct 14 03:26:40 PDT 2011
In Toad v10.6, the following would run quite happily when executed via "Execute SQL snippet at cursor (Ctrl+Enter)":

DECLARE
X NUMBER;

BEGIN

SYS.DBMS_JOB.SUBMIT
( job => X

,what => 'BEGIN my_proc; END;'

,next_date => to_date('13/10/2011 10:48:48','dd/mm/yyyy hh24:mi:ss')

,interval => 'trunc(sysdate+1) + 5/24'

,no_parse => FALSE

);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));

COMMIT;

END;

/


However, when I run the same thing in Toad v11 and execute the snippet, I get the following error:

[Error] Execution (14: 1): ORA-06550: line 14, column 1:
PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.


Was this deliberately changed to not accept the '/' on the end of the pl/sql block? Could it be changed/fixed so that it works with and without the '/' please?
__
_______________________________________