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

Fixed for next beta.

Michael

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





Message from: Boneist


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

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!


_______________________________________

Historical Messages


Author: Boneist
Date: Fri Oct 14 06:31:11 PDT 2011
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

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!

__

Author: Bert Scalzo
Date: Fri Oct 14 05:54:09 PDT 2011
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;'
__

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?
__
_______________________________________