Re: Pro*C Null column error

In article <46_at_codastore.win-uk.net> aspeir_at_codastore.win-uk.net (Allan Speir) writes:
>I've just recently compiled a Pro*C program under Oracle V7.0 using
>v1.5 of the precompiler. Previously this was compiled under Oracle
>version 6 with no trouble. It compiles OK but at run time I get
>ORA-1405 Column returns null value. This is correct because some of
>the queries do return rows containing null values. My question is what
>has changed, and is there any way to avoid this without
>explicitly coding handlers to deal with ORA-1405.

There are a couple ways that I know of. One is to use indicator variables and check them for null values. If you use an indicator variable with version 7.x you won't get a runtime error. The other way is to set one of the Pro*C command line options to put version 6 semantics into effect for this. I don't have my manual here and don't remember what it's called, but it's described clearly in the Pro*C manual in the chapter on running the precompiler.

Joe

-- 
Joe Halpin 
jhalpin_at_netcom.com 
---------------------------------------------------------------------------