Re: Perl/Oracle problem with placeholders

On 17 Jan 2001 16:15:30 GMT, M.D. Mackey <mdm1004_at_cus.cam.ac.uk> wrote:
>
> # This works:
> #my($sql)="select id from ecdsdat.table where id = '123456' ";
>
> # This doesn't
> my($sql)="select id from ecdsdat.table where id = ? ";
>
> $sth = $dbh->prepare($sql);
> $sth->bind_param(1,'123456');
> my $rv = $sth->execute();
> while (my $row = $sth->fetchrow_arrayref) {
> print $row->[0], "\n" ;
> }
>
> 8<-----------------------------------------------------------
>
> This works fine on one machine, but dies with
>
> !! ERROR: 1460 'ORA-01460: unimplemented or unreasonable conversion
> requested (DBD: oexfet error)'

What is the type of ecdsdat.table.id column?

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton@fi.muni.cz | http://www.fi.muni.cz/~adelton/
   .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, MTB, Spain.
Petition for a Software Patent Free Europe http://petition.eurolinux.org
------------------------------------------------------------------------