Search Results

I forgot to add:

In the Stored Proc, if there is an existing record, update the record. This will prevent multiple record.

I have a Shell Script which runs a PLSQL stored proc. Here is the summary:

- create LOCK file
- check if LOCK exist, if exists, abort.
- run Stored Proc and insert/update DB
- remove LOCK file...