The developers are having intermittent failures in a procedure
that looks like this.
Procedure CI IS
ltab CKPACK.tab_text; (package creates a temporay table)
ln_num_rows number;
ln_rowno number;
ls_process varchar2(12);
BEGIN
ln_num_rows := CKPACK.parse (counts rows in tempoary table)
FOR li_loop IN 1..ln_num_rows LOOP
ln_rowno := li_loop;
IF RTRIM(ltab(li_loop)) IS NOT NULL THEN
ls_process = '7';
END IF;
END LOOP;
EXCEPTION
WHEN NO DATA FOUND THEN
..
WHEN OTHERS THEN
..
END;
They get the when no data found exception at irregular
intervals. They print the values for the li_loop and
ln_num_rows. Sometimes the procedure fails then runs for the
next ten times. Sometimes it fails once then fails again the
second time. When this happens ln_num_rows will have the same
value but li_loop will be different on each try - that is the
failure occurs at different points in the loop.
I'm looking for ideas on where to look next. The developers
do not use explicit cursors. They don't initialize loop
counters. The init.ora parameters have open_cursors at 500 and
processes at 100?
Suggestions?
Thanks,
Van
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
Received on Thu Mar 02 2000 - 00:00:00 CST