Re: Cursor Loop Problem

Hey Mark,
Hello from fellow (former) Boeing employee (Long Beach Divsion).

Your cursor loop looks fine...
other problems though...

    Update rtm.rtm_ta_tims_ptss_trans

       set date_time_tr = v_date_time_tr;

Your update statement is updating the entire table for EACH row in the cursor loop.
You probably want

    Update rtm.rtm_ta_tims_ptss_trans

       set date_time_tr = v_date_time_tr     Where KEYVALUE = KEYVALUE...etc.;

2)

      DBMS.OUTPUT(v_date_time_tr_ch, v_date_tr, v_date_time_tr); I think you want

      DBMS_OUTPUT.PUT_LINE(etc....)
to print out values on the screen.

The rest is fine.

Robert Proffitt
Beckman Coulter
Brea California

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 28 1999 - 18:45:15 CDT