Does defining $exp_string between single quotes (as opposed to the " you are
using in your example) help ?
-----------------------------------
Frans Postma, (050-58) 81 852
ATOS Origin, Unix Support
"If at first you don't succeed, skydiving isn't for you"
> -----Oorspronkelijk bericht-----
> Van: Andy Rees [mailto:[EMAIL PROTECTED]]
> Verzonden: donderdag 20 februari 2003 18:19
> Aan: [EMAIL PROTECTED]
> CC: [EMAIL PROTECTED]
> Onderwerp: Perl + DBI + Oracle DBD drivers
>
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> All,
>
> I am using Perl 5.6.1 build 629, DBI 1.14, DBD-Oracle 1.06,
> DBD-Oracle8 1.06 on Windows 2000.
>
> I am trying to use the following code to transmit a string including
> hex values to Oracle.
>
> **********************************************************************
> ***********************
>
> use DBI ();
>
> my $exp_string =
> "\x90\xEB\x02\xEB\x05\xE8\xF9\xFF\xFF\xFF\x58\x83\xE8\xF1\x33\xC9\x80"
> .
> "\xA0\xD4\xD0\xE6\xFB\xE1\xC5\xEC\xFD\xF6\xF0\xED\xE1\xD4\x59\x52";
>
> $TARGET="xx.xx.xx.xx";
> $PORT="xxxx";
> $SID="xxxxxx";
>
> my $db = 'database=oras';
> my $password = 'xxxxxxxx';
> my $dsn =
> "dbi:Oracle:$db;host=$TARGET;sid=$SID;port=$PORT";
> my ($dbh)=undef;
> my $dbh = DBI->connect($dsn, $exp_string, $password,
> {PrintError=>0});
>
> **********************************************************************
> ***********************
>
> My issue that is by the time that this string is transmitted onto the
> wire a number of hex caharacters have been replaced with the hex
> value BF, this happens for a number of characters including 0x90
> (No-OP).
>
> Does anybody know why this is occurring and how I would get round it.
>
> Thanks in advance for your help
>
> Andy
>
> Andy Rees
> QinetiQ
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 7.0.4
>
> iQA/AwUBPlUN9c1fnhrqCUawEQKOpQCgmY616hGCamiq5AIb0soTHg99wO4AoKzY
> dIrdQ1t39ZLJXXAoCwPrEZOh
> =XXNL
> -----END PGP SIGNATURE-----
>
