Re: how to execute a procedure ??

From: Ron <support_at_dbainfopower.com>
Date: Thu, 12 Feb 2004 10:18:49 -0800
Message-ID: <td2dnRdbX8uWX7bdRVn-gw@comcast.com>

Hello Andr?,

One thing is to enable SQL_TRACE for the session and then check the raw file to find out where the error is.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"André Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:402b9887$1_at_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 - 12:18:49 CST