Hi
I am using command CALL , for return a resultset from PACKAGE, because the package is using (TYPE T_SO IS TABLE OF NUMBER(1) INDEX BY BINARY_INTEGER...ETC)

I want return any array length, without to define 1000 or 2000 or 9999, What Number I put in my package ([B]"{CALL ADMGID.mypackage.Gmyprocedure(?,?,{RESULTSET Value ,Table1, tabl2 ...etc)

VB Code:
  1. Public Function GetCustomer(ByVal Unidade As Byte, _
  2.                                    ByVal Consumo As Byte) As ADODB.Recordset
  3.    
  4.     On Error GoTo GetCustomerForBand_Error
  5.  
  6.         Dim str_proc        As String
  7.        
  8.                 str_proc = "{CALL ADMGID.PKG_REPORTMANAGER.GETCUSTOMEROUTBAND(?,?,{RESULTSET [B]9999[/B], PSo, PNt, PReferencia, PInstalacao, PPoste, PFase, PLogradouro, PServicePTFID, PQtdConsumida, PAnoMesRef})}"
  9.    
  10.         With g_pOracle
  11.             .AddParameter "var1", adNumeric, adParamInput, , Uni
  12.             .AddParameter "var2", adNumeric, adParamInput, , Cons
  13.              Set GetCustomerForBand = .ExecuteCommand(str_proc, adCmdText)
  14.         End With
  15.    
  16. CleanUp:
  17.     Exit Function
  18.  
  19. GetCustomerForBand_Error:
  20.     MsgBox Err.Number & "-" & Err.Description, vbCritical, "Globals::GetCustomerForBand"
  21.     GoTo CleanUp
  22.  
  23. End Function