Re: turning off autocommit in mod_plsql? (supporting transaction commit state across mod_plsql calls)

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 03 May 2006 16:01:27 +0200
Message-ID: <4458b8cf$0$4503$9b4e6d93@newsread2.arcor-online.net>

Mark C. Stock schrieb:
> i remember seeing an article on supporting transaction commit state across
> multiple mod_plsql calls, but can't seem to find the article
>
> i know this is possible, since the 'SQL Commands' window in HTMLDB/Apex
> allows AUTOCOMMIT to be toggled on and off
>
> anybody know how mod_plsql supports this, so the same feature can be
> implemented in a custom mod_plsql app?
>
> ++ mcs
>
>

What i see in the docs is definitely opposite to your statement, http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14337/concept.htm#sthref29

By tracing a htmldb session i saw that piece however:

---

PARSING IN CURSOR #44 len=186 dep=1 uid=55 oct=47 lid=55 tim=1119789769169787 hv=758058536 ad='299aedac' begin declare
  job number;
begin
dbms_job.submit(job,'wwv_flow_sc_transactions.sc_job('||:SESSION||','''||:FLOW_USER||''');');   :P1003_JOBID := job;
  :P1003_AUTOCOMMIT := 'Y';
end;
  end;
END OF STMT
PARSE #44:c=0,e=948,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,tim=1119789769169743

---

Best regards

Maxim Received on Wed May 03 2006 - 09:01:27 CDT