On 2002-04-03 02:06:15 -0800, Amr Awadallah wrote:
> yes, this works:
>
> Select * From Employee Where Name = 'Mario '
>
> but this does not work:
>
> $sth->prepare('Select * From Employee Where Name =
> ?');
This is a known behaviour of DBD::Oracle. There are several low-level
Oracle types which perl could use, unfortunately none of them works
quite as a perl programmer would expect. Search the list archives for
extensive and frequent discussions about this issue.
You can use bind_param to bind the parameter to a type which is better
suited to your needs (probably CHAR, which doesn't strip spaces, but
doesn't allow NUL characters).
hp
--
_ | Peter J. Holzer | My definition of a stupid question is
|_|_) | Sysadmin WSR / LUGA | "a question that if you're embarassed to
| | | [EMAIL PROTECTED] | ask it, you stay stupid."
__/ | http://www.hjp.at/ | -- Tim Helck on dbi-users, 2001-07-30
msg10030/pgp00000.pgp
Description: PGP signature
