Home » Developer & Programmer » Forms » How to display records into a non table base block.....
How to display records into a non table base block..... [message #210425] Wed, 20 December 2006 15:36 Go to next message
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
Re: How to display records into a non table base block..... [message #210471 is a reply to message #210425] Thu, 21 December 2006 00:00 Go to previous message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

hi,
check my post here and you should be able to modify it according to your requirements.

http://www.orafaq.com/forum/m/111031/67693/#msg_111031


regards,
Saadat Ahmad
Previous Topic: ORA-106556 (Word Viewer cannot open the document ...)
Next Topic: help
Goto Forum:
  


Current Time: Fri Dec 02 22:50:40 CST 2016

Total time taken to generate the page: 0.10918 seconds