Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible to run an Oracle PL\Sql procedure within Excel? | Excel Discussion (Misc queries) | |||
Is it possible to run an Oracle PL\Sql procedure within Excel? | Excel Discussion (Misc queries) | |||
How can Oracle DB Stored procedure be called in MS Excel? | Excel Discussion (Misc queries) | |||
Returning a resultset from Oracle Stored Procedure using ADO (VBA) | Excel Programming | |||
calling a stored procedure on MS SQL Server within MS Excel 2000 | Excel Programming |