OCI: how to execute a procedure ??

From: André Hartmann <andrehartmann_at_hotmail.com>
Date: Thu, 12 Feb 2004 16:15:19 +0100
Message-ID: <402b9887$1@olaf.komtel.net>

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,

André
:) Received on Thu Feb 12 2004 - 09:15:19 CST