Re: Using Same connect by different process

In article <1994Aug16.161429.3377_at_bme.ri.ccf.org> mcrawfor_at_bio.ri.ccf.org (Mike Crawford) writes:
>In article 7xz_at_uunet!aadt, a363674_at_aadt.com (Shirish Kumar) writes:
>>We are looking for the solution to the following problem -
>>
>>How can we use the same rolback segment from
>>two different processes? In other words, how can we
>>connect to the database from one process and let other
>>process use the same 'connect'? To make it more clear, we
>>want a process to see all the changes made by a different
>>process without commiting.
>>
>Try 'posting' the changes to the database. This is suppose to allow other
>processes the ability to see changes to the database without the changes
>actually being commited. I know you can do this in SQL*Forms 3.0... but,
>I'm not sure if this functionality exists in Pro*C.

I don't think a post will do what you want. A 'Post' is a way to tell Forms to flush any pending SQL to the database. This pending SQL (updates and inserts) is buffered within Forms until a Commit, Rollback, or Post is performed.

Steve Received on Fri Aug 19 1994 - 12:57:07 CEST