Toad v11 - execute snippet at cursor doesn't like /
Boneist <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <11227637.152741318588031328.JavaMail.SYSTEM@alvqcfw02> |
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? __ _______________________________________