Re: How to execute a stored procedure ?

1. Jorge Florindo wrote:
   >
   > 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
   For example your stored procedure name 'my_proc' after compliling *.sql file then at sql prompt type SQL > execute my_proc;

hope thsi helps

AMARENDRA
http://www.iit.edu/~nettama Received on Wed Sep 25 1996 - 00:00:00 CEST