SDE Oracle extproc future

Question

Hello,

I received the following request from my DBA:
"As you know, the installation of the software, requires to place some libraries at the server level. These libraries are then accessed via a plsql LIBRARY object.

Could you ask if they plan to “de-support/remove” this approach ? An alternative would be to provide the same functionality but using Java instead. The LIBRARY would then use java code stored in the DB itself, avoiding the need of this EXTPROC thingy that we need to setup now."

Any opinion ?

Thanks !

Nicolas

BillFox · Answer

Reads like it would be worth it for the Oracle DBA to install ArcMap client on the Oracle server to minimize upgrade grief.

NicolasGIS · Answer

Hello,

I am talking about this procedure:

https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/configure-oracle-extproc.htm

That we have to do at each upgrade.

Thanks

BillFox · Answer

Nope,

I read the SDE part and it made be think you might be running the ArcSDE Application server environment.