Executing Store Procedure

Fellow
I have a ADO Connection and a Store procedure to be assign to a recordset.
I have my code Thus:

Dim sybconn as New ADODB.Connection
Dim rstproc as New ADODB.Recordset


Sybconn.Open "oracon",UID,PWD
set rstproc.Activeconnection = sybconn

Sybconn.Execute "Name of the store procedure"
set rstproc = sybconn.execute"......"

This is the code in summary. it is returninig and error.


What I want to do is that I want to execute a store procedure and get the field using a recordset.

Waiting for your feed back

Hi omodara!
Please post the error message that you are receiving.