Large resultset causes ORA-00600
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Large resultset causes ORA-00600

  1. #1
    Join Date
    Apr 2001
    Posts
    13

    Large resultset causes ORA-00600

    Hi,

    I've got a problem reading a resultset from Oracle 8i. I'm using Delphi with ADO.

    I call a stored procedure which returns a recordset. The size of this recordset can wary greatly. However, if I define the recordset big enough, the execution of the SQL code takes a long time, after which Oracle gives me this error:

    ORA-00600: internal error code, arguments [KGHALO2], [0], [], [], [], [], []

    I make the SP call with TADOCommand object. The script look like this:

    {CALL SHAPE_PARAMS_PKG.GET_SHAPES_PARAMS_FINLAND(MachineName, Null, {resultset 16778, o_ShapeName, o_ParamName, o_CharVal})}

    The problem is the 16778 value after the recordset keyword. 16777 still works, but one more causes the error. The problem is, the returned set can be much greater than 16777. If I set the value to 16777 and the resultset is greater, I get ORA-06513: PL/SQL: index for PL/SQL table out of range for host language array.

    Do you know how I could either return larger recordsets without an error or split the recordset into smaller parts?

    Thanks,

    Happosai

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    have a look at the metalink site, 44 hits on KGHALO2.

    if you can't find what you are looking for from the metalink serach you should open a tar

    steve
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Happosai,

    I think your program is not written for scalability.
    Today you can solve the problem for x number of rows. Tmo what will happen if y ( >x) number of rows to be returned?

    You must rewrite the code to send/get fixed number of rows at all time. This way you can gurantee ur client that ur program will work for ever.

    Tamil

Posting Permissions

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



Click Here to Expand Forum to Full Width