Re: Fun and games with Pro*C

It seems like it is too much trouble for the error message people to provide that simple llittle bit of info (for more fun and games, SQLERRM in PL/SQL in Reports 6i is a one time use only function - the first thing you do with it better be to set some var to its value, cause the second time you refer to it things like constraint names will be missing).

To be able to see the SQL statements that a program issues, at least under Windoze, go to www.toadsoft.com, click on 'download' and then get yourself SQL Monitor (it is free).

"Michael L. Hostbaek" <carlos_at_pez.dk> wrote in message news:slrnbedv4l.tu5.carlos_at_freebsdcluster.dk...
> Group,
>
> I am forced to debug an old Pro*C program, that have been semi working
> for a year or two. It is giving some trouble, so I was kinda hoping
> someone from this list could help me out.
> I finally got preprocessor working, without error on the code - and gcc
> is compiling the code without too many erros ;)
>
> 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...
>
> Thanks in advance..
>
> /mich
>
>
> --
> Regards,
> Michael L. Hostbaek
> -= So long, and thanks for all the fish.. =-
>
Received on Wed Jun 11 2003 - 06:37:03 CDT