Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2008
    Posts
    5

    Unanswered: ora-0600 error found

    hi,
    i want csv of column values(with out loop) in pl/sql using oracle-9i.
    For it,
    i use xml in query. syntax is

    RTRIM
    ( xmlagg (xmlelement (abcd, unit_virtual_fund ||' : '||nof_unit||' units'||', ')
    order by unit_fund ||' : '||nof_units||nof_unit||' units').extract ('//text()'), ', ' )


    here unit_virtual_fund and nof_unit is the column name
    but at my end i got successfully result,
    but on another system(production system) , i got error

    -600ORA-00600: internal error code, arguments: [qerpxAddPSRinfo3], [2], [], [], [], [], [], []


    In both system i use in table structure

    LOGGING
    NOCACHE
    PARALLEL ( DEGREE DEFAULT INSTANCES DEFAULT );



    what should i do?

  2. #2
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    Contact Oracle Support and open a Service Request. ORA-00600 errors are internal system errors. You can also login to MetaLink and use the ORA-600 lookup tool, but you should follow up with an SR.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The Ora-00600 is a catchall error that oracle uses to indicate that an unexpected error occurred and it doesn't know what to do.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •