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
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
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
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);
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:
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
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
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
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
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!
10 matches
Mail list logo