SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Prevent calling a procedure at the same time from different computers

muttleychessJul 18 2019 — edited Jul 23 2019

is there any way to prevent a procedure from being called more than once from different computers from a front end

I tried to flag using

DBMS_APPLICATION_INFO.SET_ACTION('EXECUTING');

And then check through the V$SESSION

but the DBA of one of the clients prohibits the use of this view (V$SESSION) in the procedures

Is there any other way to perform this control, this is as soon as a procedure is started, no other user can execute it until the end?

using

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

This post has been answered by Billy Verreynne on Jul 19 2019

Jump to Answer

Added on Jul 18 2019

15 comments

2,343 views