FAQ
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)

Search Discussions

  • John Scoles at Apr 10, 2006 at 1:24 pm
    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"" <ogomez@epq.com.co> 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)
  • Oscar Gomez at Apr 10, 2006 at 1:43 pm
    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" <scoles@pythian.com>
    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"" <ogomez@epq.com.co> 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)
  • Kevin Moore at Apr 12, 2006 at 3:16 am
    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)



  • Oscar Gomez at Apr 17, 2006 at 4:29 pm
    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 <kmoore@esntech.com>
    To: Oscar Gomez <ogomez@epq.com.co>
    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 -------
  • Teemu Kivioja at Apr 18, 2006 at 3:03 pm
    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)

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedApr 10, '06 at 1:03p
activeApr 18, '06 at 3:03p
posts6
users4
websitedbi.perl.org

People

Translate

site design / logo © 2022 Grokbase