Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: auto-commit availabe like on sybase ß
Frank Zimmer suggested that:
> Hi
> we have to migrate a database application from a powerbuilder sybase
> application to a web-based oracle application.
>
> Inside the sybase app you can setup some transactions without an
> explicit commit.
> Is that also possible with oracle ?
The 'nasty' feature/option you want to do is a:
SQLCA.autocommit = TRUE
or change SQLCA to the transaction object you define in PB. As Thomas says, you really need to review your entire application as Sybase's ASA or Sybase's ASE have completely different transaction and locking mechanisms than Oracle. In ASA, for example, dirty reads are completely acceptable and the default, whereas Oracle does not allow this (in default isolation mode). This of course makes multi-user applications perform very different, and you need to write your application accordingly.
Good luck. Received on Tue Dec 21 2004 - 09:23:11 CST