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: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 31 Aug 2005 07:12:36 -0700
Message-ID: <1125497513.453056@yasure>


Kleist 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"
>
> TIA for any clue
>
> K.

ORA-00000 is not an error as you acknowledge and as it clearly states. Write code to handle it.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Aug 31 2005 - 09:12:36 CDT

Original text of this message

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