BTW, Output of the data is:
0100BB0000669064400500379910000000000001000000000063EBBDAB090B481794B284 9B0CA2D85EF908F8145FAEF2043B308CE8A256E8B7E1ABE1198D84A519BEDD3B511075B2 17AD243B5D9B9A91BD837BB0158EDB42A3C372A39DC2B4FCF1BF5C21C25458714ECD7164 000000000000000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000000000000000 00000000000002AF6C2663AC19659F00009467000000014899D243 ... Which is correct. Joe -----Original Message----- From: Tim Bunce [mailto:[EMAIL PROTECTED] On Behalf Of Tim Bunce Sent: Wednesday, August 06, 2008 3:51 AM To: Orcino, Joe Cc: [email protected]; Phelan, Tom Subject: Re: Bug in DBD::Oracle v 1.21 ? 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. ************************************************************************************** This e-mail is confidential, the property of NDS Ltd and intended for the addressee only. Any dissemination, copying or distribution of this message or any attachments by anyone other than the intended recipient is strictly prohibited. If you have received this message in error, please immediately notify the [EMAIL PROTECTED] and destroy the original message. Messages sent to and from NDS may be monitored. NDS cannot guarantee any message delivery method is secure or error-free. Information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. We do not accept responsibility for any errors or omissions in this message and/or attachment that arise as a result of transmission. You should carry out your own virus checks before opening any attachment. Any views or opinions presented are solely those of the author and do not necessarily represent those of NDS. To protect the environment please do not print this e-mail unless necessary. NDS Limited Registered office: One Heathrow Boulevard, 286 Bath Road, West Drayton, Middlesex, UB7 0DQ, United Kingdom. A company registered in England and Wales Registered no. 3080780 VAT no. GB 603 8808 40-00 **************************************************************************************
