sql - Set text of text item dynamically from table in oracle forms -
i using oracle forms builder 6i. have created table stores names of items in form, example detail50.z1, detail50.z2 , on. column name 'detail'.
now question is, in loop in 'when_new_record_instance' want give items new text value. example detail50.z1 := 'value 1'
.
i have created procedure declared cursor (c_curs_det
) fetches item name table, , in loop, want set text other value. tried:
for v_rec in c_curs_det loop set_item_property(v_rec.detail, xxx, 'some value'); end loop;
but can't find can put on 'xxx'. can me?
you use copy
procedure:
for v_rec in c_curs_det loop copy('some value', v_rec.detail); end loop;
Comments
Post a Comment