problem DBD-Oracle-1.17 linux enterprise AS

i have this error when i made interface program perl with oracle 10g trough
DBD module.
DBD::Oracle::st execute failed: ORA-00600: internal error code, arguments:
[kpofdr-long], [], [], [], [], [], [], [] (DBD ERROR: error possibly near <*>
indicator at char 37 in 'select
itmpar, texpar
from useru.<*>par
where ciapar = :p1
and fampar = :p2 ') [for Statement "select
itmpar, texpar
from useru.par
where ciapar = ?
and fampar = ? " with ParamValues: :p1=0, :p2='py-ley'] at
../1230.pl line 28.

but,if I execute it for the second time it work ok.

thanks
--
Open WebMail Project (http://openwebmail.org)
------- End of Forwarded Message -------


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

Fw: Re: problem DBD-Oracle-1.17 linux enterprise AS

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"
To: dbi-users@perl.org
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"" wrote in message
news:20060410124910.M66121@epq.com.co...
> i have this error when i made interface program perl with oracle 10g
trough
> DBD module.
> DBD::Oracle::st execute failed: ORA-00600: internal error code, arguments:
> [kpofdr-long], [], [], [], [], [], [], [] (DBD ERROR: error possibly near
<*>
> indicator at char 37 in 'select
> itmpar, texpar
> from useru.<*>par
> where ciapar = :p1
> and fampar = :p2 ') [for Statement "select
> itmpar, texpar
> from useru.par
> where ciapar = ?
> and fampar = ? " with ParamValues: :p1=0, :p2='py-ley']
at
> ./1230.pl line 28.
>
> but,if I execute it for the second time it work ok.
>
> thanks
> --
> Open WebMail Project (http://openwebmail.org)
> ------- End of Forwarded Message -------
>
>
> --
> Open WebMail Project (http://openwebmail.org)
>
------- End of Forwarded Message -------


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

Re: problem DBD-Oracle-1.17 linux enterprise AS

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:

>i have this error when i made interface program perl with oracle 10g trough
>DBD module.
>DBD::Oracle::st execute failed: ORA-00600: internal error code, arguments:
>[kpofdr-long], [], [], [], [], [], [], [] (DBD ERROR: error possibly near <*>
>indicator at char 37 in 'select
> itmpar, texpar
> from useru.<*>par
> where ciapar = :p1
> and fampar = :p2 ') [for Statement "select
> itmpar, texpar
> from useru.par
> where ciapar = ?
> and fampar = ? " with ParamValues: :p1=0, :p2='py-ley'] at
>./1230.pl line 28.
>
>but,if I execute it for the second time it work ok.
>
>thanks
>--
>Open WebMail Project (http://openwebmail.org)
>------- End of Forwarded Message -------
>
>
>--
>Open WebMail Project (http://openwebmail.org)
>
>
>
>
>

Re: problem DBD-Oracle-1.17 linux enterprise AS

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
To: Oscar Gomez
Sent: Tue, 11 Apr 2006 20:11:44 -0700
Subject: Re: problem DBD-Oracle-1.17 linux enterprise AS

> 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:
>
> >i have this error when i made interface program perl with oracle 10g trough
> >DBD module.
> >DBD::Oracle::st execute failed: ORA-00600: internal error code, arguments:
> >[kpofdr-long], [], [], [], [], [], [], [] (DBD ERROR: error possibly near <*>
> >indicator at char 37 in 'select
> > itmpar, texpar
> > from useru.<*>par
> > where ciapar = :p1
> > and fampar = :p2 ') [for Statement "select
> > itmpar, texpar
> > from useru.par
> > where ciapar = ?
> > and fampar = ? " with ParamValues: :p1=0, :p2='py-ley'] at
> >./1230.pl line 28.
> >
> >but,if I execute it for the second time it work ok.
> >
> >thanks
> >--
> >Open WebMail Project (http://openwebmail.org)
> >------- End of Forwarded Message -------
> >
> >
> >--
> >Open WebMail Project (http://openwebmail.org)
> >
> >
> >
> >
> >
------- End of Original Message -------

Re: problem DBD-Oracle-1.17 linux enterprise AS

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


At 07:49 10.4.2006 -0500, you wrote:
>i have this error when i made interface program perl with oracle 10g trough
>DBD module.
>DBD::Oracle::st execute failed: ORA-00600: internal error code, arguments:
>[kpofdr-long], [], [], [], [], [], [], [] (DBD ERROR: error possibly near <*>
>indicator at char 37 in 'select
> itmpar, texpar
> from useru.<*>par
> where ciapar = :p1
> and fampar = :p2 ') [for Statement "select
> itmpar, texpar
> from useru.par
> where ciapar = ?
> and fampar = ? " with ParamValues: :p1=0, :p2='py-ley'] at
>./1230.pl line 28.
>
>but,if I execute it for the second time it work ok.
>
>thanks
>--
>Open WebMail Project (http://openwebmail.org)
>------- End of Forwarded Message -------
>
>
>--
>Open WebMail Project (http://openwebmail.org)