Re: Exec statement

On 7 Sep 2005 10:45:23 -0700, 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 ?

execute is a *sqlplus* statement. It is also nothing more than begin <procedure name>; end;
/

--
Sybrand Bakker, Senior Oracle DBA