Re: I have a PL/SQL problem in oracle web server

Each execution of a procedure from OWS is a complete transaction with no preservation of state between interactions. You can however make use of the transaction feature in OWS 3.x where a connection state can be maintained between interactions.

John Thwaites
AlliedSignal, Inc.
Polymers Division

Erik de Jong wrote:

> I don't know much about oracle web server but couldnt you just use
> <alter session disable commit in procedure> somewhere.
>
> See You,
> Erik de Jong.
>
> On Mon, 13 Jul 1998 01:39:21 GMT, leirace_at_my-dejanews.com wrote:
>
> >Hi, all
> > I have two procedure in my oracle web server.
> >The first insert some record in database . I want to
> >commit or rollback the operation at the second procedure;
> >But when I do this, I found the first procedure auto commit
> >when the procedure finish. I can't rollback in others procedure.
> >Please tell me How can I do this problem.
> >
> > thanks!!!
> > leirace
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Jul 14 1998 - 08:24:36 CDT