Re: Fun and games with Pro*C

"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