[DBI-users] problem DBD-Oracle-1.17 linux enterprise AS

If you could include which version of DBI, DBD:Oracle and some of your
original perl code it would give us a better idea on how to debug this.

So far a ORA-00600 error can be any one of a number of problems. One is a
'time out error' which might explain why it runs the second time.

cheers

John Scoles

""Oscar Gomez"" <[email protected]> wrote in message
news:[email protected]...

the versions DBI y DBD are:
DBD::Oracle -- 1.16, DBI -- 1.50
I was working in oracle 8i with modules DBD::Oracle -- 1.12
DBI -- 1.30 without problems.

connect :
sub _connect
{
my $wdsn = "dbi:Oracle:orcl";

$ENV { ORACLE_HOME } = "/ora8/soft/oracle/product/10.1.0/db_1/";
$ENV { ORACLE_SID } = "epqdb";

$dbh = DBI->connect ( $wdsn, 'user', 'pw')
or
&error ( "BATCH", txt => "connect" );

$dbh->{ AutoCommit} = 0;
}

prepare :
$sth_par = $dbh->prepare ( "select
itmpar, texpar
from useru.par
where ciapar = ?
and fampar = ? ")
or
$batch->error (txt => "p720");

execute :
$sth_par->bind_param ( 1, 0 );
$sth_par->bind_param ( 2, 'py-ley', DBI::SQL_CHAR );
$sth_par->execute
or
print "p110 $dbh->errstr";

thanks

---------- Forwarded Message -----------
From: "John Scoles" <[email protected]>
To: [email protected]
Sent: Wed, 10 May 2006 09:25:02 -0500
Subject: Re: problem DBD-Oracle-1.17 linux enterprise AS

If you could include which version of DBI, DBD:Oracle and some of your
original perl code it would give us a better idea on how to debug this.

So far a ORA-00600 error can be any one of a number of problems. One is a
'time out error' which might explain why it runs the second time.

cheers

John Scoles

""Oscar Gomez"" <[email protected]> wrote in message
news:[email protected]...
------- End of Forwarded Message -------

Oscar,

Are there errors in your alert log? The ora-600 is a "generic" message.
It's quite possible oracle generated a trace file that may also help.

Kevin

Oscar Gomez wrote:

the solution is to duplicate one of the fields of select. it is problem of the
module?. for example:
select
itmpar, texpar, texpar
from par
where ciapar = :p1
and fampar = :p2 '

--
Open WebMail Project (http://openwebmail.org)


---------- Original Message -----------
From: Kevin Moore <[email protected]>
To: Oscar Gomez <[email protected]>
Sent: Tue, 11 Apr 2006 20:11:44 -0700
Subject: Re: problem DBD-Oracle-1.17 linux enterprise AS
------- End of Original Message -------

Hi,

I had the same problem in a similar system (Oracle 10.1, Enterprise Linux
AS). A script running many queries always failed but at a different place
at each run.

The problem vanished after running the Patch 3612581 for the Oracle bug:
Bug 3612581 OERI[kpofdr-long] can occur on SELECT

Best regards,
Teemu Kivioja