| How to display records into a non table base block..... [message #210425] |
Wed, 20 December 2006 15:36  |
jun.alcoriza
Messages: 1
Registered: December 2006
|
Junior Member |
|
|
Hi,
Can anybody help me how to display records into a non table base block.... Find below is my coding but it only display the last record in the first line in the block.
PROCEDURE CREATE_CARTON_QUESTION IS
CURSOR car_c IS
select /*+ rule */ question_id, question_description
from WHOP.QADB_QUESTIONS
where question_category = 'Carton'
and question_active_flag = 'Y';
v_found VARCHAR2(10);
v_status boolean;
v_error varchar2(150);
car_r car_c%rowtype;
begin
first_record;
for car_r in car_c loop
---populating carton questions
:la_carton.carton_question_id := car_r.question_id;
:la_carton.carton_question_answer := 'N';
:la_carton.carton_error_details := null;
:la_carton.attribute2 := car_r.question_description;
next_record;
end loop;
end;
Thanks in advance.
Regards,
Jun
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
