Why the error of out of range at large return

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • cschang

    Why the error of out of range at large return

    Error: "ORA-06513: PL/SQL: index for PL/SQL table out of range for host language array ORA-06512: at line 1
    /vd2/asp/BinInactivityRe sults.asp, line 249"

    the error only appeared when I had a large number records return (> 12000), anything less 7000 is fine (I had not tried any number between). Wonder why? I am using oracle 8.1.7, retrun table type reocrds with my IIS 4 on NT 4

    'ASP sysntax as
    ...
    set commBinAct = server.CreateOb ject ("ADODB.Command ")
    commBinAct.Acti veConnection = connBinAct
    commBinAct.Comm andText = pkgcall
    commBinAct.Comm andType = adCmdText
    commBinAct.Para meters.Refresh
    ' .. other command object parameters

    set rsBinAct = server.CreateOb ject ("ADODB.Records et")
    rsBinAct.Cursor Location = adUseClient
    rsBinAct.Open commBinAct

    ....
    l_rowcount = rsBinAct.Fields ("o_rowcount ")
    ....

    'display the recordset in HTML table

    Do While NOT rsBinAct.EOF
    ..

    Loop

    ' to regain the all records for other use
    IF cint(l_rowcount ) > 0 Then
    commBinAct.Para meters(5) = 1
    commBinAct.Para meters(6) = cint(l_rowcount )
    rsBinAct.Close
    rsBinAct.Open commBinAct ' <--- line 249
    Session("Inacti veBIN") = rsBinAct.GetRow s
    End If

    set commBinAct = Nothing
    rsBinAct.Close
    set rsBinAct = Nothing
    connBinAct.Clos e
    set connBinAct = Nothing

Working...