Jim,

I replied in your previous thread....

-------------
Are you using a ref cursor as an OUT parameter from a procedure, or as the
return value from a function?

I know that if a PLSQL function returns a ref cursor then in VBA you would
set the return value to an ADO recordset...

Example here...
http://www.oracle-base.com/articles/...Recordsets.php

Tim

--
Tim Williams
Palo Alto, CA


--
Tim Williams
Palo Alto, CA


"Jim Heavey" wrote in message
...
Well, I am making progress. I have been successful in creating parms for
a
stored procedure and getting a value returned to me. The problem is I
doctored my Oracle Procedure to return a integer rather then the Ref
Cursor
that I really want to have returned.

Does anyone know what Type (DataType.Enum) I should be using to get back
and
be able to process a Oracle Ref Cursor?

Second question. When I use the following command to create a parameter,
the Intellisense which pops up indicates that the last parameter value of
the
method "Value" is not required, but yet it requires me to enter this
amount.
Since the parameter being created is an output paramter, I do not want to
place a value in here. How do I enter the command so I do not have to
enter
the optional parameter value?

cmd.Parameters.Append cmd.CreateParameter("o_Rows", adArray,
adParamOutput, , 0)

In this situation I am entering zero, but I do not want to enter anything
there... If I do not place anything there and close the parenthesis, I get
a
compile error.

Thanks in advance for your assistance!!!!