From: Chris ( Val ) on

swapnakrishnan2k(a)gmail.com wrote:
> I am trying to use an exec statement to run a script on Dbvisualizer.
> However, I get this error
>
> exec test1.sql
>
> 11:27:53 [EXEC - 0 row(s), 0.000 secs] [Error Code: 900, SQL State:
> 42000] ORA-00900: invalid SQL statement
> ... 1 statement(s) executed, 0 row(s) affected, execution time 0.000
> sec
>
> I'm sure the sql statement in the script is not the problem cause it
> runs when i run it seperately.
>
> Could somebody help me ?

Look up the ampersand '@' and the 'START' command
in the SQL reference.

Cheers,
Chris Val