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)
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 <[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 > 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
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)
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" <[EMAIL PROTECTED]>
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"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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
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] > 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) >
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)
