LongReadLen, lengthb() and Oracle

2005-12-13 Thread Ron Savage
Hi Folks The DBI docs for LongReadLen say to use LENGTHB() for Oracle, but that gives me an error: ORA-00932: inconsistent datatypes: expected NUMBER got LONG when I do: select max(lengthb(a_session) ) from sessions; And, yes, sessions is for CGI::Session, and a_session is of type long. This

can't locate "require_version"

2005-12-13 Thread Patrick Danley
I figured it out. Begin forwarded message: From: Patrick Danley <[EMAIL PROTECTED]> Date: December 13, 2005 11:38:42 AM EST To: dbi-users@perl.org Subject: can't locate "require_version" i would like to thank those that offered help with my Bareword:'DBI::SQL_INTEGER" not allowed while "str

re: Oracle 10g and DBD::Oracle

2005-12-13 Thread Jared Still
It appears that you are seeing the parse done by DBD::Oracle to describe the table. Look at the DBI docs for ora_check_sql. Turn it off and the extra parse should go away. Jared On Thu, 2005-12-08 at 11:00 -0500, Peter Santos wrote: > Dear users, > I'm hoping to get some insight into why oracle

can't locate "require_version"

2005-12-13 Thread Patrick Danley
i would like to thank those that offered help with my Bareword:'DBI::SQL_INTEGER" not allowed while "strict subs" in use error. i now receive a new error: -- Can't locate object method "require_version" via package "DBI" at /sw/ lib/perl5/5.8.6/darwin-thread-multi-2level/DBD/Pg.pm line 36.

FYI ping no longer works via DBI:ODBC:mysql

2005-12-13 Thread Martin J. Evans
Just in case anyone else stumbles into this I've just spent quite a bit of time trying to work out why my scripts are not working as intended to discover that ping no longer works via DBI:ODBC:mysql (at least in mysql-connector 3.51.12) (to sql server, oracle etc they are fine). DBD::ODBC attempts