How to execute a stored procedure ?
From: Herve Garfagni <garfahe_at_gemse.fr>
Date: 1996/09/25
Message-ID: <3248D841.3134_at_gemse.fr>#1/1
Date: 1996/09/25
Message-ID: <3248D841.3134_at_gemse.fr>#1/1
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.
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.frReceived on Wed Sep 25 1996 - 00:00:00 CEST