Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: stored procedured call error

Re: stored procedured call error

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Thu, 1 Sep 2005 05:43:55 +0000 (UTC)
Message-ID: <df64er$a8k$1@klatschtante.init7.net>


On 2005-08-31, Kleist <kleist_at_tlen.pl> wrote:
> Hello,
>
> I have a problem with calling stored procedure from PHP
> using Oracle 8 functions.
>
> The line which produces the error is
>
> $s = OCIParse($db_link, "
>
> CODE OF STORED PROCEDURE
>
> ");
>
> OCIExecute($s); <-- ?
>
> Connection to the DB is ok, before these lines couple of
> queries are executed well.
>
> The code of SP is ok too, since compilation from the client
> produces no errors.
>
> The error code is produced by mentioned line is:
> "ORA-00000: normal, successful completion"

What is 'CODE OF STORED PROCEDURE' exactly?

How do you know that the line produces an error if the error is ORA-00000?

You provide far too less context for anyone to be of any help.

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/
Received on Thu Sep 01 2005 - 00:43:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US