Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Using commit/rollback with Oracle and RDO
We have:
VB 4 applications running on NT 4.0 machine
VB 5 ODBC driver V2.? (because it works)
RDO V1.?
SQL*Net V2.3
Oracle V7.3.2 database on SCO UNIX server
We are trying to figure out how to use stored procedures and commit/rollback with RDO. We try doing things like
rdoConn.BeginTrans ret_cd = rdoConn.CreateQuery ('{call stored_proc (?, ?) }') if ret_cd = good_Query then rdoConn.EndTrans ' or whatever a "commit" equivalent may be else rdoConn.Rollback ' or whatever the syntax is for a rollback end if
and also substituting "rdoConn.Execute ('commit')" for EndTrans, etc.
With any method, committing or rolling back do not seem to work. Everything always ends up being committed. Any suggestions? Code examples would be nice. Would going to RDO V2 help? We will also be trying to call multiple stored procedures in a row, trying to ipmlement the ability to rollback all the way before the calling of the first stored procedure. Any special things to watch out for there? If anyone knows of a relevant Microsoft knowledge base article, please let me know.
-- tkupp at pacifier dot comReceived on Wed Oct 08 1997 - 00:00:00 CDT
![]() |
![]() |