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.