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

**URL:** <https://forums.toadworld.com/t/toad-v11-execute-snippet-at-cursor-doesnt-like/10785>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [October 14, 2011, 5:26am UTC](https://forums.toadworld.com/t/toad-v11-execute-snippet-at-cursor-doesnt-like/10785 "2011-10-14T05:26:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Boneist](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/boneist/32/145_2.png) [@Boneist](https://forums.toadworld.com/u/Boneist)\
**Post date:** [October 14, 2011, 5:26am UTC](https://forums.toadworld.com/t/toad-v11-execute-snippet-at-cursor-doesnt-like/10785/1 "2011-10-14T05:26:40Z")

</div>

DECLARE

BEGIN

SYS._ **DBMS\_JOB.SUBMIT** _

,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

);

COMMIT;

END;

/

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?

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [October 14, 2011, 7:54am UTC](https://forums.toadworld.com/t/toad-v11-execute-snippet-at-cursor-doesnt-like/10785/2 "2011-10-14T07:54:09Z")

</div>

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;’

---

<div class="post-metadata">

**Author:** ![Boneist](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/boneist/32/145_2.png) [@Boneist](https://forums.toadworld.com/u/Boneist)\
**Post date:** [October 14, 2011, 9:41am UTC](https://forums.toadworld.com/t/toad-v11-execute-snippet-at-cursor-doesnt-like/10785/3 "2011-10-14T09:41:12Z")

</div>

null;  
end;

/

If the begin is on line 1 of the editor, it fails with the PLS-00103 error, if it’s on line 2, then it runs without erroring.

Weird!

ETA: If I highlight the block (including the /) and then execute snippet, it works, even if it starts on line 1.

I doubt it’s that - the code runs fine in v11 if I strip off the /

Having looked into it further, it seems that if I have the block of code starting on line 1 of the editor, it complains about the / whereas if I press return to take the start of it to line 2, it’s fine.

Have reproduced with:

begin

Message was edited by: Boneist

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [October 14, 2011, 10:25am UTC](https://forums.toadworld.com/t/toad-v11-execute-snippet-at-cursor-doesnt-like/10785/4 "2011-10-14T10:25:46Z")

</div>

Fixed for next beta.

Michael

---

<div class="post-metadata">

**Author:** ![Boneist](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/boneist/32/145_2.png) [@Boneist](https://forums.toadworld.com/u/Boneist)\
**Post date:** [October 14, 2011, 11:46am UTC](https://forums.toadworld.com/t/toad-v11-execute-snippet-at-cursor-doesnt-like/10785/5 "2011-10-14T11:46:41Z")

</div>

Great - thanks!