topic Re: SDE Oracle extproc future in Data Management Questions

SDE Oracle extproc future

NicolasGIS — Mon, 23 Nov 2020 05:33:10 GMT

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

Re: SDE Oracle extproc future

BillFox — Fri, 20 Nov 2020 16:34:58 GMT

what version of products is this for?

Re: SDE Oracle extproc future

NicolasGIS — Fri, 20 Nov 2020 17:50:04 GMT

Were are running SDE 10.8 on Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production.

We are planning to upgrade to 19c.

Are you saying that it depends on the versions ?

I had the feeling it applies to all versions.

Thanks

Re: SDE Oracle extproc future

BillFox — Fri, 20 Nov 2020 20:00:06 GMT

Nope,

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

Re: SDE Oracle extproc future

NicolasGIS — Mon, 23 Nov 2020 05:36:22 GMT

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

Re: SDE Oracle extproc future

BillFox — Mon, 23 Nov 2020 19:33:58 GMT

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