On Tue, Aug 05, 2008 at 04:53:16PM -0700, Orcino, Joe wrote:
> $osaq->bind_param(':ImmPacket', $packetCard
> { ORA_TYPE => ORA_RAW }) ;
> For each execution (in a loop), I get no errors and the queue is
> incremented (indicating receipt of a record), but in the database, my
> binary :ImmPacket field is empty in the queue!
> I have made sure that the variable I am passing ($packetCard) does
> contain 207 bytes of binary information.
I think the ORA_RAW type needs to be encoded as pairs of hex digits,
and not as a binary string. In which case you need to use pack("H*",...).
(I might be wrong though, it's been a while since I've used RAW.)
Tim.