Table Triggers on Oracle

gregglarkin

gregglarkin

Legendary Poster
I have a question from one of my developers:

"When working with JDE table triggers, at what point is the table/database actually updated ?

I have some event rules in the 'After record is updated' event, but when I query the table (F41021), I see the values have not been updated as yet. Shouldn't the new values be in the table in the 'After record is updated' event ? This is in E900 8.98.32 using the Oracle database."

When we work with SQL server, table triggers work fine. Now we are working with Oracle and things are not behaving as expected. The developer has search the knowledge jungle with no hits. I also had him place an SR with Oracle. I have a six pack bet that JDElist will come up with the answer faster. Ready? Set? Go!

- Gregg
 
Gregg,

the table trigger is probably wrapped in a transaction - which will not be visible in the database to other processes until the transaction is committed. Pretty basic stuff.

As an aside . . . is your developer SURE he wants to use JDE Table Triggers?
 
Back
Top