Toad World® Forums

Error when executing procedure from SQL script in v6.0


#1

Recently installed SQL Navigator v6 and ran into a problem when executing procedures from a SQL script using the “exec” command. I’ve narrowed it down to there being a single line comment following the command. The error does not occur when another executable statement (e.g. select something from somewhere;) follows the exec command. This did not occur in v5.5

exec dbms_output.put_line(‘Hello’);
– your comment here

Will either return an application exception or the following:

17:39:23 ORA-06550: line 2, column 17:
17:39:23 PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:
17:39:23 begin case declare end exception exit for goto if loop mod
17:39:23 null pragma raise return select update while with
17:39:23
17:39:23
<< close current delete fetch lock insert
17:39:23 open rollback savepoint set sql execute commit forall merge
17:39:23 pipe

Using a block comment (/* your comment here */) allows the exec command to work properly.

Go figure.


#2

Parser issue. The problem is fixed in 6.1.0.1090 Beta
Please download the latest Beta - http://sqlnavigator.inside.quest.com/ann.jspa?annID=251 and check it out and let us know if the issue has been addessed in the latest Beta build.

Rgds,
Andrew