LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Calling Oracle Stored Procedure

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to run an Oracle PL\Sql procedure within Excel? mowee Excel Discussion (Misc queries) 1 January 22nd 10 03:54 PM
Is it possible to run an Oracle PL\Sql procedure within Excel? mowee Excel Discussion (Misc queries) 0 January 22nd 10 03:04 PM
How can Oracle DB Stored procedure be called in MS Excel? Amol Excel Discussion (Misc queries) 1 January 7th 07 10:05 AM
Returning a resultset from Oracle Stored Procedure using ADO (VBA) mary Excel Programming 0 December 30th 05 05:26 PM
calling a stored procedure on MS SQL Server within MS Excel 2000 Witold Domienik Excel Programming 0 March 2nd 04 10:47 AM


All times are GMT +1. The time now is 06:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"