I am not sure what procedure are being called out of this one, but perhaps that is the problem? See, we had a problem with commits happening, and we didn't want them to until the entire process was through, in case of needing a roll back.
After doing a lot of tracking from include files to include files, we found the commit buried in a include that was called from an include file. I am not sure if that is what is happening, but hopefully it helps. Sometimes the commits are not obvious, and not something that you have programmed in yourself. Again, this might be more specific to the organization I was working at and the software we were using (PeopleSoft).
Denise
-----Original Message-----
From: Siva Prasad Juluri [mailto:jsiva@BANGALORE.IMRGLOBAL.COM]
Sent: Monday, September 11, 2000 11:57 AM
To: SQR-USERS@list.iex.net
Subject: Re: COMMIT and ROLLBACK
I have a doubt that whenever END-SQL is encountered AUTO-COMMIT is happening. Will be it set in environment variables or any settings need to be done..
Thanx,
Siva
>>> Dan_Johnson@WRIGHTEXPRESS.COM 09/12/00 12:27AM >>>
To my knowledge SQR only auto commits when the program ends. Until then you
can commit or rollback as necessary.
Dan
-----Original Message-----
Siva Prasad Juluri
Sent: Monday, September 11, 2000 2:33 PM
Hi guys,
My problem is similar to the problem which earlier one of friends
asked.
What will happen when you come out of BEGIN-SQL and END-SQL loop.
If auto-commit happens what needs to be done to ROLLBACK.
Thanx
Cheers,
Siva
>>> biggswl@VT.EDU 08/15/00 08:23PM >>>
"Turner, Ivan" wrote:
> The sources I am consulting are giving conflicting information
with regards
> to an Oracle db. Which is the prefered method of issunig a
COMMIT? Is it
> the SQR COMMIT command or the SQL COMMIT enclosed in a
BEGIN-SQL/END-SQL
> block? I have an Oracle RDBMS.
This is not directly related to your Q, but we have discovered that,
on our
system, SQR seems to do a COMMIT by default, you must specify
ROLLBACK if that
is what you want. SQL on the other hand, assumes ROLLBACK unless
specifically
told to COMMIT.
--wb
--
"It should be challenging, but not impossible, to come up with an
acceptable
password."
Karen Herrington - New criteria for Oracle passwords
_______________________________
*** Confidentiality Notice ***
Proprietary/Confidential
Information belonging to IMRglobal Corp.
may be contained in this message.
If you are not a recipient indicated or
intended in this message (or responsible
for delivery of this message to such
person), or you think for any reason that
this message may have been addressed to
you in error, you may not use or copy or
deliver this message to anyone else.
In such case, you should destroy this
message and kindly notify the sender
by reply email.
_______________________________
*** Confidentiality Notice ***
Proprietary/Confidential
Information belonging to IMRglobal Corp.
may be contained in this message.
If you are not a recipient indicated or
intended in this message (or responsible
for delivery of this message to such
person), or you think for any reason that
this message may have been addressed to
you in error, you may not use or copy or
deliver this message to anyone else.
In such case, you should destroy this
message and kindly notify the sender
by reply email.