Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I'm looking to notify another system when a WMX job (of particular job type) has been closed. And I know this will be a call to an Oracle package. I'm considering a database trigger because it seems to be the most straightforward approach, but cautious because I'm not finding a lot of chatter in the forums. Are there any "gotchas" (WMX or Oracle) to look out for with this approach?

Notes:

  • Workflow Manager for ArcGIS 10.0
  • Oracle 11g
  • Want to avoid using custom notifiers and/or python scripts on client workstations.
share|improve this question

1 Answer 1

up vote 1 down vote accepted

I've been running a trigger on the JTX_JOBS table for a few weeks (in a development environment).

Thus far, the only issue was an exception thrown when subsequent procedures query the the JTX_JOBS table: ORA-04091: table XXXX is mutating, trigger/function may not see it

Initial, poor trigger design on my part and easily fixed by updating stored procedures to receive additional values from the :NEW pseudo-record.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.