SDE Oracle extproc future

65
5
Friday
Labels (2)
Highlighted
Regular Contributor

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

Reply
0 Kudos
5 Replies
Highlighted
MVP Frequent Contributor

what version of products is this for?

Reply
0 Kudos
Highlighted
Regular Contributor

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

Reply
0 Kudos
Highlighted
MVP Frequent Contributor

Nope,

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

Reply
0 Kudos
Highlighted
Regular Contributor

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

Reply
0 Kudos
Highlighted
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.

Reply
0 Kudos