Re: Procedure stops for no reason

Look for a trace file in the directory pointed to by the user_dump_dest parameter.
Or trace the procedure with alter session set sql_trace = true. There must be *some* error.
You are not suppressing exceptions by any chance?

Hth,

Sybrand Bakker, Oracle DBA

<terry_stjean_at_my-deja.com> wrote in message news:8n0qfh$dsh$1_at_nnrp1.deja.com...
> I have a procedure which copies records from one table to another by
> grouped by a batch number. Each batch can have from 30,000-200,000
> records. After processing anywhere from 10-15 batches, the procedure
> just ends. There doesn't appear to be any problems with the data or the
> procedure. Does this have anything to do with the extents or is it
> something else.
>
> Terry
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 11 2000 - 00:00:00 CEST