Re: Error using TOAD Software to execute a script

From: agis <stag_at_hq.acn.gr>
Date: Thu, 23 Sep 2004 15:49:22 +0300
Message-ID: <ciugoi$173g$1@ulysses.noc.ntua.gr>

"Danilo" <danilomoreira_at_yahoo.com.br> wrote in message news:746aac83.0409230431.1de68ed2_at_posting.google.com...
>I Have a script and in SqlPLus i have sucessfull, but when retrive
> execute in TOAD Software i have error found:
> ------------------------------
> The Script is:
> ------------------------------
> COMMIT;
>
> BEGIN
> TESTE;
> END;
> ---------------------------
> Error Found in TOAD Software:
> ---------------------------
> LOADING: C:\Program Files\Toad\TSCRIPT.SQL
>
> Commit
> BEGIN
> TESTE
> ORA-06550: linha 3, coluna 0:
> PLS-00103: Encontrado o símbolo "end-of-file" quando um dos seguintes
> símbolos era esperado:
> := . ( @ % ;
> END
> END
> ORA-00900: instrução SQL inválida
> ----------------------------------
>
>
> What I do?
>
> Thanks All
>
> Danilo

I believe u must do

commit;

declare
begin
teste;
end; Received on Thu Sep 23 2004 - 07:49:22 CDT