Re: Code Review

This is how I fixed:

  LOOP

     dbms_sql.column_value (cursor1, 1, lv_val);
	 rows_processed := dbms_sql.fetch_rows(cursor1);
     EXIT WHEN rows_processed = 0;

  END LOOP; In article <8fptnc$9ig$1_at_nnrp1.deja.com>,   Ethan Post <epost1_at_my-deja.com> wrote:
> Thanks, I have made the changes, the only problem is is that
> rows_processed=0 right before the line
>
> while rows_processed > 0 LOOP
>
> Therefore the entire loop is getting skipped. I can figure it out from
> here most likely. I assume it isn't really set until fetch_rows is
> called.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
http://www.freetechnicaltraining.com/home/ethan


Sent via Deja.com http://www.deja.com/
Before you buy.