Accessing Stored Procedure from Oracle DB and get output

Discussion created by vinayaksj on Oct 8, 2013
Latest reply on Oct 9, 2013 by MPurohit-esristaff

I have a normal database connection with Oracle platform. This database contains one stored procedure which I need to access using connection properties. This stored procedure gives me output of type 'OracleTable' in the parameter named 'SDS_SYS.T_NUMBER_TAB'(it may/may not be physically existing).
So, is it possible to access and execute this stored procedure with ArcObject in .Net ? Available platforms are- ArcMap 10.1 SP1, Silverlight 5, Oracle 11g client.
If yes, a sample code or link to related query would be helpful.