One thing comes to my mind.
Make a job to execute the procedure, and then execute the job. Jobs have that
serial functionality implemented. If you start the job and it is already started by
someone, the job does nothing for you. And you have the dba_jobs_rinning view, where
you can find if job is running now.
The other way is to make it manually - set something at the beginning of the
procedure, and then unset it on exit.

Rgds,
Yavor

Ashiq Shamsudeen wrote:

> Hi All,
>
> Is there any way around to lock a procedure ??? My requirment
> is only once user should execute a procedure at a time,till he
> finish the execution others should not execute this procedure.
> This funcitionallity is available in sql server ,so i want to
> know whether someother to achieve this.
>
> thanx
> A.Ashiq
>
> _______________________________________________________________________
> Odomos - the only mosquito protection outside 4 walls -
> Click here to know more!
> http://r.rediff.com/r?http://clients.rediff.com/odomos/Odomos.htm&&odomos&&wn
>
> --------
> Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page