One blank line in list item
Posted
by rima
on Stack Overflow
See other posts from Stack Overflow
or by rima
Published on 2010-06-02T08:30:21Z
Indexed on
2010/06/02
8:33 UTC
Read the original article
Hit count: 250
Oracle
|oracleforms
Hi there. I try to write a code to fill my list item in oracle form builder.
I do it by write a function to handle this.
list_index number(10) := 1;
clear_list(list_item1);
FOR I IN (Select id,desc FORM table1)
LOOP
ADD_LIST_ELEMENT('list_item1',list_index,desc,id);
list_index := list_index + 1;
END LOOP
list_item1 := get_list_element_value('list_item1',1);
my result in output is like this:
x1
x2
x3
x4
<a blank field>
but in my database table I just have
x1
x2
x3
x4
would you help me please to how find what's my problem that I have one more space in my list item.
© Stack Overflow or respective owner