How to handle error ORA-01405?

Dear Oracle experts,

this is probably a newbie question, but I have only limited access to manuals, so this is my only hope.

I have written a simple Pro*C application that select rows from an Oracle database using host arrays to speed up performance over the network. In fact, I just modified sample program sample3.pc to suit my needs.

Everything worked fine while my Pro*C was version 6. Now I have a new machine with version 7, and now the program exits with the error ORA-01405: fetched column value is null. The error manual says this was only a warning, and the program should handle this error. Well, how should I do this?

Almost all of the rows have NULL values in one or more columns, so I have to find a solution. I tried with "WHENEVER ERROR CONTINUE". That works, but now there is only one column returned per fetch instead of 200 (size of host array). This seriously degrades performance  over the network.

Please mail any helpful suggestions or solutions directly to me, since I am unable to keep up with the traffic in this newsgroup.

Thanks for any help,
Richard

--
+----------------------------+-------------------------------------------+


| Dr. Richard Spitz          | INTERNET: spitz_at_ana.med.uni-muenchen.de   |

| EDV-Gruppe Anaesthesie     | Tel     : +49-89-7095-3421                |

| Klinikum Grosshadern       | FAX     : +49-89-7095-8886                |


| 81366 Munich, Germany      |                                           |


+----------------------------+-------------------------------------------+