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

From: Berny <bernhard.voelker_at_siemens.com>
Date: Wed, 02 Oct 2002 14:44:40 +0200
Message-ID: <anepnp$9uv$1_at_news.mch.sbs.de>



[Quoted] Hello NG,

[Quoted] 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 Received on Wed Oct 02 2002 - 14:44:40 CEST

Original text of this message