DBMS_PIPE handles nulls?

From: <jboes_at_my-dejanews.com>
Date: Thu, 13 Aug 1998 20:46:20 GMT
Message-ID: <6qvjas$sdj$1@nnrp1.dejanews.com>

How does the DBMS_PIPE package handle null values?

I'm sending fields to a process which reads from the pipe. My receiving code looks like this:

DBMS_PIPE.UNPACK_MESSAGE(:msgField INDICATOR :msgField_i);

(I have no idea if the INDICATOR syntax has any impact here, but it is syntactically correct.)

When I unpack a NULL from the message, I get

ORA-01405: fetched column value is NULL

This seems to happen even though the UNPACK_MESSAGE call is bounded by a block with an exception handler.

--
Jeff Boes jboes_at_qtm.net
http://www.qtm.net/~jboes/

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 13 1998 - 15:46:20 CDT