topic Accessing Stored Procedure from Oracle DB and get output in Data Management Questions

Accessing Stored Procedure from Oracle DB and get output

VinayakJogade — Wed, 09 Oct 2013 03:55:28 GMT

Hi,

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.

Thanks,

Re: Accessing Stored Procedure from Oracle DB and get output

MandarPurohit — Wed, 09 Oct 2013 14:38:19 GMT

You can explore the IWorkspace.ExecuteSQL method to execute the stored procedure from ArcObjects.

As mentioned on the ArcObjects API reference link:

"The statement can be any DDL (data definition language) or DML (data manipulation language) statement but cannot return any result sets."

This limitation can be addressed by modifying the stored procedure.
for e.g. writing the results to a table, and the results read, say, using query classes.

Mandar