SDE Oracle extproc future

1011
5
11-20-2020 08:17 AM
NicolasGIS
Occasional Contributor III

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

0 Kudos
5 Replies
BillFox
MVP Frequent Contributor

what version of products is this for?

0 Kudos
NicolasGIS
Occasional Contributor III

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

0 Kudos
BillFox
MVP Frequent Contributor

Nope,

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

0 Kudos
NicolasGIS
Occasional Contributor III

Hello,

I am talking about this procedure:

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

That we have to do at each upgrade.

Thanks

0 Kudos
BillFox
MVP Frequent Contributor

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

0 Kudos