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: Urgent: "Error" ORA-00000 - Normal, successful completion

Re: Urgent: "Error" ORA-00000 - Normal, successful completion

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Fri, 30 Apr 1999 14:24:34 +0100
Message-ID: <WyndGQAS8aK3EwUI@ahardy.demon.co.uk>


In article <7fsppu$u9o$2_at_srvlinux2.elogica.com.br>, Fábio Ávila <farp_at_elogica.com.br> writes
>I am getting the "ORA-00000 - Normal, successful completion" "error" when I
>try to INSERT or UPDATE data, from our client application, in some tables in
>my database.
>
>Our client application is written in Delphi, when the error ORA-00000 is
>issued by the server, the application thinks it's receiving an error, so it
>doesn't perform the operation needed.
>
>We have tried many different tablespace configurations with the table but
>none worked. We didn't have this problem before, so we think it might be
>somehow related to a larger amount of data in the table and perhaps with
>some RAW or CLOB fields we created later on.
>
>

Sounds like a problem with your application - for some reason you've decided to ask for an SQL error when there isn't one. A bit like RAISEing an exception which is caught by a WHEN OTHERS to output the SQL error, but the RAISE was not due to an SQL error so you got the 'OK' message.

Andy
--
Andy Hardy. PGP key available on request


Received on Fri Apr 30 1999 - 08:24:34 CDT

Original text of this message

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