Strange behaviour commit/rollback buttons

[Marco van der Linden]

Hi,

I've noticed some strange behaviour of the commit/rollback buttons. Using PLD 7.0.3.1123 against Oracle Applications sometimes when I query a table (e.g. wf_item_attribute_values) the commit/rollback buttons are activated. wf_item_attribute_values is a _real_ table so there's no database link hidden in a view to cause this behaviour, and I'm definitely not using for update.

It's not really a problem, but weird anyway.

 

[Marco Kalter]

Oracle will implicitly start a transaction when querying a database link or embedded objects. When the complete result set is fetched, the implicit transaction is closed.

 

[Marco van der Linden]

Ah ,I think I understand now. The table has a column of type wf_event_t which is an object with member functions.

Thanks for the explanation.