Build a text file of Oracle Stored Procedure Return Columns
Posted on 2008-10-20
I am trying to use ado ext and ado to access an Oracle database and retrieve the output columns that the procedure for a fairly large set of stored procedures.
I can get the list of procs using the following:
ADOXCatalog.ActiveConnection = adoConn
procs = ADOXCatalog.Procedures
and look for a proc name using the following:
For Each proc As ADOX.Procedure In procs
If proc.Name = "Some ProcName Then
But I do not see how to get back the returned columns.
Any and all help on this would be greatly appreciated.