Check completion status from log table [message #328357] |
Thu, 19 June 2008 19:20  |
mohapatra
Messages: 24 Registered: August 2006 Location: New Jersey
|
Junior Member |
|
|
Please advise me.
I want to write a procedure which when called from a shell script ,should search for success status of a procedure.
I insert procedure status at the end of the code of the procedure.For refernce ..
INSERT INTO log_table
(id,type_code,datetime,proc_name,status,
message,upd_user_id,upd_timestamp)
VALUES
(id_generator.NEXTVAL,i_type_code,sysdate,
'TEST_PROC','SUCCESS','Completed succesfully,
user,sysdate);
Now I will run procedure 'TEST_PROC' from a shell script , then i want to write a procedure which will search for the 'Success' status of TEST_PROC .
Challenges:
what will i use in my where condition.( as i may run the proc 2-3 times in 1 hour)
How eill i return the message to shell script.
|
|
|
|