Large resultset causes ORA-00600

[Happosai]

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

[stmontgo]

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

[tamilselvan]

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