RE: LongReadLen, lengthb() and Oracle

2005-12-15 Thread Ron Savage
On Wed, 14 Dec 2005 15:03:42 -0700, Reidy, Ron wrote: Hi Ron What data type is 'a_session'? I have never worked with this It's a long, as per Oracle's error msg below. ERROR at line 1: ORA-00997: illegal use of LONG datatype -- Cheers Ron Savage, [EMAIL PROTECTED] on 15/12/2005

RE: LongReadLen, lengthb() and Oracle

2005-12-15 Thread Ron Savage
On Wed, 14 Dec 2005 17:00:43 -0500, Ted Behling wrote: Hi Ted http://www.arikaplan.com/oracle/ari80597b.html Thanx. The problem arose when I got an error that LongReadLen was not set and LongTruncOk was 0 (quoting vaguely from memory). So I was trying to find out the length of a column's

RE: LongReadLen, lengthb() and Oracle

2005-12-15 Thread Ron Savage
On Thu, 15 Dec 2005 19:55:28 +1100, Ron Savage wrote: This reminds me: In DBI V 2 I'd like a new option: $$dbh{'MakeLikeSimple'} = 1; It would of course be on by default... -- Cheers Ron Savage, [EMAIL PROTECTED] on 15/12/2005 http://savage.net.au/index.html Let the record show: Microsoft is

Minor bug in DBD::ODBC 02simple test

2005-12-15 Thread Martin J. Evans
Around about line 128 DBD::ODBC's 02simple test does: # Note, this test will fail if no data sources defined or if # data_sources is unsupported. my @data_sources = DBI-data_sources('ODBC'); #diag(Data sources:\n\t, join(\n\t,@data_sources),\n\n); cmp_ok($#data_sources, '', 0, data sources test);

Re: DBD::Oracle test failure under DBI 1.49

2005-12-15 Thread Michael Gray
On Fri, 9 Dec 2005, Tim Bunce wrote: On Fri, Dec 09, 2005 at 11:45:44AM +, Michael Gray wrote: DBD::Oracle 1.16 fails a test for me when building under DBI 1.49. All was fine with the identical build under DBI 1.48. This is on SuSE Linux 9.3, 32-bit Athlon. In a nutshell:

DBD ODBC question - $dbh-{odbc_exec_direct}

2005-12-15 Thread Ryan Stille
I am working on a script that inserts records into a Progress database. The script connects via DBI and odbc. As I loop through each potential record to import, I query the database for some info. Occasionally I get errors like this: DBD::ODBC::st execute failed: [OpenLink][ODBC][Progress

Re: DBD ODBC question - $dbh-{odbc_exec_direct}

2005-12-15 Thread louis gonzales
Try sth-finish() after the sth-execute() i see you're catching the return values too, as in: $rc = sth-execute() are you actually using them for anyting? if not, i'd suggest not capturing them, because they're doing nothing but executing more instructions. statements. perhaps the stale

RE: DBD ODBC question - $dbh-{odbc_exec_direct}

2005-12-15 Thread Ryan Stille
louis gonzales wrote: Try sth-finish() after the sth-execute() I tried this and it did indeed stop the errors, even without the $dbh-{odbc_exec_direct} = 1 line. Actually I added it after the fetch, I wasn't sure if I should clean up $sth before I fetch() from it. What was happening by not

RE: LongReadLen, lengthb() and Oracle

2005-12-15 Thread Ron Savage
On Thu, 15 Dec 2005 20:03:53 +1100, Ron Savage wrote: Hi Idiot In DBI V 2 I'd like a new option: $$dbh{'MakeLikeSimple'} = 1; That joke was meant to be MakeLifeSimple... -- Cheers Ron Savage, [EMAIL PROTECTED] on 16/12/2005 http://savage.net.au/index.html Let the record show: Microsoft is not

RE: DBD ODBC question - $dbh-{odbc_exec_direct}

2005-12-15 Thread louis gonzales
Hey Ryan, Actually, I noticed the stale handle error you were getting and with a little intuition, without digging in too deep, figured it had to do with the method being called and not closing finishing before the next iteration of the same method call. Glad it solved the issue!