Home » SQL & PL/SQL » SQL & PL/SQL » Check completion status from log table (Oracle 9.2)
icon9.gif  Check completion status from log table [message #328357] Thu, 19 June 2008 19:20 Go to next message
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.
Re: Check completion status from log table [message #328360 is a reply to message #328357] Thu, 19 June 2008 20:28 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>what will i use in my where condition.( as i may run the proc 2-3 times in 1 hour)
What is/are the requirements?

>How eill i return the message to shell script.
one way would be to use SPOOL RESULTS.DAT
Previous Topic: Trim Out Special Character...
Next Topic: Schema or Instance
Goto Forum:
  


Current Time: Tue Feb 11 11:24:47 CST 2025