Re: Pro*C: ora-01405 when UNPACK_MESSAGE(empty string)

[Quoted] On Wed, 02 Oct 2002 14:44:40 +0200, Berny <bernhard.voelker_at_siemens.com> wrote:

>Hello NG,
>
>When unpacking an empty string with dbms_pipe.unpack_message(),
>and the sender packed a (even hardcoded) empty string (''),
>I get the following in my Pro*C program:
> ORA-01405: fetched column value is NULL
>
>Another program (which does the same job on the same machine)
>accepts empty strings.
>
>What have I missed? Compile options? Libraries? ...
>
>Oracle 8.0.6.2, SunOS 5.5.1
>
>Thank you for your time,
>Berny

[Quoted] indicator variables. Generally speaking any column that can return null in a fetch needs an indicator variable. 8.0.6 is desupported more than a year ago, and SunOS 2.5 has been desupported too.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Oct 02 2002 - 22:46:47 CEST