Hi Everyone,

I am trying to execute a stored procedure on sql server, here is my stored procedure and my code:

PROCEDURE PROC1 AS lmsg1 VARCHAR2(80);
BEGIN
lmsg1:='TEST1';
INSERT INTO TABLE1 VALUES ('DONE.', l_err_msg, 'PROC1', SYSDATE);
COMMIT;
END;

Here is my code:
Dim cm As New ADODB.Command
Dim rs As New ADODB.Recordset

cm.ActiveConnection = db
cm.CommandType = adCmdStoredProc
cm.CommandText = "PROC1"
cm.CommandTimeout = 15

rs.CursorType = adOpenStatic
Set rs = cm.Execute()
end sub

I am getting an error "Type mismatch" can someone help me or give a hint?