Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Using commit/rollback with Oracle and RDO

Using commit/rollback with Oracle and RDO

From: RastM <tkupp_at_pacifier.com>
Date: 1997/10/08
Message-ID: <343ae38d.0@news.pacifier.com>#1/1

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 com
Received on Wed Oct 08 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US