Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
Windows and .NET
.NET Stored Procedures
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: May 4, 2011 12:14 PM by
Checking if Script is Already Running
Mar 28, 2011 3:38 PM
I am writing a batch file that will fire off an Oracle Stored Procedure using something along these lines:
IF "%%~nxV" EQU "FILE1" sqlplus username/password@prod @c:\folder\sql\sqlfile.sql
If there some way to know if SQLFILE.SQL is already running so we don't call the process twice? Preferabbly from a batch file / command prompt.
This content has been marked as final.
Show 1 reply
Re: Checking if Script is Already Running
May 4, 2011 12:14 PM
in response to
You might set specific action or client info in dbms_application_info and then eventually look for it.
The other option is using global context or a table.
BTW, I'd move it to procedure itself (to let it being processed just once) or consider using queues/scheduler_jobs.
You have not mentioned which DB version you're using.