i'm not an oracle DBA, but i know you need to tweak the proc to return a 

ref cursor for ADO. after that, it's simple:



set objCmd = SetDBCommand(objConn,"{CALL PKG.PROC(?,?)}",adCmdText)

objCmd.Parameters.Append objCmd.CreateParameter("PARAM1",adInteger, 

adParamInput,,param1)

objCmd.Parameters.Append objCmd.CreateParameter("PARAM2",adInteger, 

adParamInput,,param2)

set rs = objCmd.Execute



hope this helps,



eric



> hi,

>   I want to execute a stored procedure in oracle which returns a 

Recordset.

>  The signature of the stored procedure contains the ref cursor as an out 

> parameter .

> 

>    How do i call the OleDBCommand objects execute method.

>   It gives me an error saying unknown error.

> 

>  I assing the command object all the parameters expected by the stored 

> procedure in the same order as expected.

>  

> I passed the ref cursor parameter as a varialbe of type object 

> 

> whent the command:

>  oledbDataReader=oledbcommand.executeReader() is executed it throws an 

> error.

>  

> Please help me out if anyone know the answer.

>  

>  Thanks And Regards

>  

>  Mohit Navare