I am getting the following error.

Error Type:
ADODB.Parameters (0x800A0E7C)
(dbStoredProcedureCall.ReturnRecordSet.GetRecordSe t) Stored Procedure Name: sp_Exec_SQL Error: Parameter object is improperly defined. Inconsistent or incomplete information was provided.
/emeeting/Find_Reservations.asp, line 638


Code is:


    parmArray(1,1) = adVarChar
    parmArray(3,1) = 8000
    parmArray(4,1) = SQL
    oDBCall_sp.GetRecordSet clsConn.Connection, "sp_Exec_SQL", parmArray ,oRS, returnValue

    If Err.Number = 0 then
        if oRS.State <> 0 then
            If Not (oRS.EOF = True And oRS.BOF = True) Then%>
                <table nowrap border="0" width="100%">
                    <th bgcolor="#003187" class="intranetLinks">Confirmation<br>Number</th>
                    <th bgcolor="#003187" class="intranetLinks">Meeting Date</th>
                    <th bgcolor="#003187" class="intranetLinks">Short Description</th>
                    <th bgcolor="#003187" class="intranetLinks">Status</th>



and Stored procedure is:

DECLARE @RC int
DECLARE @SQL varchar(8000)
SELECT @SQL = NULL
EXEC @RC = [eMeeting].[dbo].[sp_Exec_SQL] @SQL
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: eMeeting.dbo.sp_Exec_SQL'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
PRINT @PrnLine

I am not getting the reason. Please any one can help me.



Kishore Kumar
Software Engineer
TATA Consultancy Services.

Which line of code is 638?

oDBCall_sp.GetRecordSet clsConn.Connection, "sp_Exec_SQL", parmArray ,oRS, returnValue

is the 638 line

Kishore Kumar
Software Engineer
TATA Consultancy Services.