On 08/05/09 15:26, E R wrote:
On Fri, May 8, 2009 at 5:40 AM, Charles Jardine <c...@cam.ac.uk> wrote:
You do not say which perl driver your are using to talk to Oracle.
The DBD::Oracle driver binds all placeholders as strings by default.
Are you using DBD::Oracle?
Yes, I am using DBD::Oracle.
What other perl drivers are there for Oracle?
You could be using DBD::ODBC and and Oracle ODBC driver.
If its DBD::Oracle, you could turn on tracing at level 3
with
DBI->trace(3)
You will then be able to see the type of the bind in the trace.
I will be supprosed if it is not 'varchar'.
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679
