,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
In Toad v10.6, the following would run quite happily when executed via “Execute SQL snippet at cursor (Ctrl+Enter)”:
X NUMBER;( job => X SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ’ || to_char(x));
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?