Prev: iSQL*Plus Problem - ORA-12162: TNS:net service name is incorrectly specified
Next: TIMEOUT ON CONTROL FILE ENQUEUE
From: Chris ( Val ) on 7 Sep 2005 17:37

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

First  |  Prev  | 
Pages: 1 2
Prev: iSQL*Plus Problem - ORA-12162: TNS:net service name is incorrectly specified
Next: TIMEOUT ON CONTROL FILE ENQUEUE