Re: Can I have one connection with dif.transactions

In article <94rtcs$jne$1_at_nnrp1.deja.com>,   chiappa_at_my-deja.com wrote:
> 2 answers :
>
> a) to commit DMLs issued in forms´ triggers WITHOUT commit alterations
> made in the data blocks, use the database commit in your trigger :
> standard.commit;
>
> b) 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.
> >

Tkanks for the answer, but I still having the problem because is a huge form that executes POST_FORM, and in the PRE-INSERT of some blocks there are DML, so if I make a standard COMMIT , they will be send to the database.

Yor answer helps me to decide to solve the problem in another way.
Thanks again,
Gonzalo.

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 26 2001 - 10:49:49 CST