Unanswered: Shell script to SQLPlust works - sometimes...
Any advice would be a big help.
First, let me say that I am not a unix or oracle person - but that it is now my duty to keep these systems up and running.
7 unix shells calls a single oracle stored procedure. The procedure doesn't always respond when it is complete and the task continues to run on the unix box. On some days, all 7 of them complete. Other days, only 3 or 4 of them complete. That is, they all delete all the records every day, but they don't always go away on the unix side when they are finished.
CREATE OR REPLACE PROCEDURE NSF_OWNER_CON.nsf_user_con_table_purge
tbl_name in varchar,
days_bk in integer,
col_name in varchar,
err_cde out number,
name_tbl out varchar,
err_mess out varchar,
del_count out number,
out_date out date