Re: How to execute a stored procedure ?

You don't need the Procedure in the execute statement.

Ie, in your example, you would just need

EXECUTE dbsynchro

If you still have problems, try wrapping a Begin and End around it if you're not at the SQL*Plus prompt.

Good luck, :)
Ed
Herve Garfagni <garfahe_at_gemse.fr> wrote:

>Hi,
 

>I am using an application based on Oracle and I am trying to add a
>stored procedure to this application although I have no documentation on
>Oracle.
 

>I successfully create this procedure with the command CREATE in isql.
>But I am not able to run this procedure using EXECUTE.
 

>Here is what I did:
>CREATE PROCEDURE dbsynchro from "dbsynchro.oracle.proc.sql"
>EXECUTE PROCEDURE dbsynchro
>>>> error ORA-00900 invalid SQL statement.
 

>I guess something is missing in my EXECUTE statement. Can anyone tell me
>the right syntax?
 

>Thanks a lot.
 

>--
>Herve GARFAGNI (Connectivity Solutions Operation)
>GE Medical Systems - Europe (C.P. 23) | Tel.: (33) 1 30 70 49 11
>283 rue de la Miniere, B.P. 34 | Fax: (33) 1 30 70 42 26
>78533 BUC, FRANCE | email: garfahe_at_gemse.fr
Received on Wed Sep 25 1996 - 00:00:00 CEST