Re: Exec statement

From: Chris ( Val ) <chrisval_at_bigpond.com.au>
Date: 7 Sep 2005 14:37:44 -0700
Message-ID: <1126129064.672000.183650@g44g2000cwa.googlegroups.com>

swapnakrishnan2k_at_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 Received on Wed Sep 07 2005 - 16:37:44 CDT