Re: Pro*C: ora-01405 when UNPACK_MESSAGE(empty string)
From: Berny <bernhard.voelker_at_siemens.com>
Date: Fri, 04 Oct 2002 08:32:38 +0200
Message-ID: <anjcm7$2gd$1_at_news.mch.sbs.de>
>
>
>
> 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
Date: Fri, 04 Oct 2002 08:32:38 +0200
Message-ID: <anjcm7$2gd$1_at_news.mch.sbs.de>
Sybrand Bakker wrote:
> 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
>
>
>
> 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
Thank you for your answers,
but the sending procedure does definitly not pack NULL,
but an hardcoded empty string:
DBMS_PIPE.PACK_MESSAGE('');
:rc := DBMS_PIPE.SEND_MASSAGE('my_pipe');
Any clues?
Berny Received on Fri Oct 04 2002 - 08:32:38 CEST