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: Fun and games with Pro*C

Re: Fun and games with Pro*C

From: Harald Maier <maierh_at_myself.com>
Date: Wed, 11 Jun 2003 18:16:26 +0200
Message-ID: <m3vfvcwpwl.fsf@ate.maierh>


"Michael L. Hostbaek" <carlos_at_pez.dk> writes:

> Group,
>
> The program dies, with a :
> ERREUR : sqlerrmc = ORA-01405: fetched column value is NULL
>
> I'd very much like to locate what it is having trouble fetching, and
> where. I have look through the SQL statements in the code, and tried
> setting debug printf's here and there - without too much success. So
> my questions is... Would it be possible to make the ORA-01405 a bit
> more verbose ? Fx. printing the last SQL statement...

Either ignore the error 1405 or use the _NVL_ sql function on the column that produces the error to map the null value to another value.

Harald Received on Wed Jun 11 2003 - 11:16:26 CDT

Original text of this message

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