Re: Stored Procedure with concurrent SELECT / UPDATE

From: joel garry <>
Date: Tue, 8 Feb 2011 09:51:22 -0800 (PST)
Message-ID: <>

On Feb 8, 12:29 am, Mau C <> wrote:

> So I'm able to obtain a Java result set through the Sys_RefCursor.
> I'm not really sure that is a "multi-process access" safe procedure...

That it isn't was my first though when I saw the pragma autonomous, but I haven't really worked it out. I was thinking of a race condition, but Mark's suggestion of select for update ought to avoid that.

Here are some examples:


-- is bogus.
""Give a man a fish, or he will destroy the only existing vial of
antidote." -
Received on Tue Feb 08 2011 - 11:51:22 CST

Original text of this message