Re: Intermittent Failures in Procedure

Hi.

 Is LTAB a PL/SQL table?
 If yes then it's possible that your SGA are is too small and  LTAB is flushed out of it ( just a guess ).

 HTH. Michael.

In article <07f606ec.88017c0b_at_usw-ex0108-063.remarq.com>,   Van Messner <vmessnerNOvmSPAM_at_discovernet.com.invalid> wrote:
> 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!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 02 2000 - 00:00:00 CST