Re: How to execute a stored procedure ?

Herve Garfagni 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

Hi Herve

Are you talking about ORACLE?
I don't know the ORACLE commands that you refer in your mail.

Regards
Jorge Received on Wed Sep 25 1996 - 00:00:00 CEST