Re: Can I have one connection with dif.transactions

2 answers :

1. to commit DMLs issued in forms´ triggers WITHOUT commit alterations made in the data blocks, use the database commit in your trigger : standard.commit;
2. the relational theory says : when a user´s connection start a DML, one transaction is started. While don´t occurs a COMMIT or a ROLLBACK, this transaction will be open, even if the user start another prog, IN THE SAME CONNECTION. In your case (Forms) when you changes data in the screen, the Forms blocks are marked as "dirty", BUT the correspondent DMLs (insert, update, delete) ARE NOT send immediatly to the database; SO, if you make DMLs by-hand, only these DMLs are in the database.

[]s

     Chiappa

In article <94rs7u$iqg$1_at_nnrp1.deja.com>,   Gonzalo <gonzarg_at_my-deja.com> wrote:
> Hi,
> I'using Oracle Forms 4.5 - Oracle 8.0.5 (Solaris),
> I want to make a log when a specific form is closed, but I
> don't want to affect the normal operation of the form.
> The problem is that if I make a commit for the log, I can
> save changes of the form that I don't want.
> I've solved the problem saving the log, after the rollback
> or exit, using some triggers.
>
> But the question is, can I make a commit of same data,
> without saving all the changes?
> I ONLY want to commit the log, not the other changes , that
> colud be discarded.
>
> TIA,
> Gonzalo.
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 26 2001 - 07:17:22 CST