Re: OCI: how to execute a procedure ??

> Hi there,
>
> I have tried to execute a stored procedure through OCI using the
> OCIStmtExecute function. However when I send "execute myprocedure(somearg)"
> it gives me ORA-00900 invalid SQL statement. I gett he same with "execute
> myprocedure(somearg);" or "myprocedure(somearg)" or "myprocedure(somearg);".
> The server does have PL/SQL installed and my procedure compiled without
> errors. if i type "execute myprocedure(somearg);" in SQL*Plus it works fine.
>
> Any clues how to fire it through OCI?
>
> Thanks,

Andre

Try
  begin
    name_of_stored_proc(arguments)
  end;
instead of
  execute name_of_stored_proc(arguments)

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch