Hi I have the following code:
VB Code:
  1. Function RunFODBPackage(ByVal SQLString As String, ByVal BindVars As String) As ADODB.Recordset
  2. '###############################################################################
  3. '   Description : XXX
  4. '
  5. '   Return      : An ADO record set.
  6. '###############################################################################
  7.  
  8. Dim lrs As ADODB.Recordset
  9. Dim cmd As ADODB.Command
  10. Dim stream As ADODB.stream
  11. Dim streamOut As ADODB.stream
  12.     If basADO_Tools.OpenDBConn(gconnfodb, basGlobal.GetConnectionString("RESEARCH")) Then
  13.        
  14.         'Retrieve the file and update the parameter value
  15.         Set stream = New ADODB.stream
  16.         stream.Charset = "iso-8859-1"
  17.         stream.Type = adTypeText
  18.         stream.Open
  19.        
  20.         Set streamOut = New ADODB.stream
  21.         streamOut.Charset = "iso-8859-1"
  22.         streamOut.Type = adTypeText
  23.         streamOut.Open
  24.  
  25.         'stream.WriteText BindVars, adWriteLine
  26.         stream.LoadFromFile ("c:\BindVars.xml")
  27.        
  28.  
  29.         Set cmd = New ADODB.Command
  30.         gconnfodb.CursorLocation = adUseServer
  31.         With cmd
  32.              Set .ActiveConnection = gconnfodb
  33.             .Properties("SPPrmsLOB") = True
  34.             .CommandText = "PK_XML_UTILITIES.P_GET_XML"
  35.             .CommandType = adCmdStoredProc
  36.             .Parameters.Append cmd.CreateParameter("PV_QUERY", adVarChar, adParamInput, 8000, SQLString)
  37.             .Parameters.Append cmd.CreateParameter("PV_XSLT_FILENAME", adVarChar, adParamInput, 255)
  38.             .Parameters.Append cmd.CreateParameter("PC_XML", adLongVarChar, adParamOutput, 900000000)
  39.             .Parameters.Append cmd.CreateParameter("PC_BINDS_XML", adLongVarChar, adParamInput, stream.Size + 1, stream.ReadText)
  40.             .Execute
  41.         End With
  42.         Set RunFODBPackage = lrs
  43.     End If
  44. End Function

The error occurs when the line ".Execute" runs. Does anybody know how to get around this problem?

Thanks in advance