Home » Developer & Programmer » Forms » dymamic dropdown list problem
dymamic dropdown list problem [message #233261] Wed, 25 April 2007 07:37 Go to next message
oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka
Member
Sir,
my problem is drop down list,i have create dynamic drop down list
this is the drop down list procedure.it works fine

/*PROCEDURE Add_List_Dynamic(p_List in Varchar2) IS
CURSOR Dept_Cur IS (SELECT DeptNo,DName FROM Dept);
A NUMBER := 0;
BEGIN
CLEAR_LIST(p_List);
FOR Dp IN Dept_Cur LOOP
A := A + 1;
ADD_LIST_ELEMENT(p_List,A,dp.DName,dp.DeptNo);
END LOOP;
END;*/

but my problem ADD_LIST_ELEMENT ,i want to pass only one value DNAME not DEPTNo
when i pass one value but a earror occur
"wrong number of argument is call ADD_LIST_ELEMENT "

i attach my work,anybody view it and please help me............and better solution...

Raihan(Dhaka.Bangladesh).
Re: dymamic dropdown list problem [message #233263 is a reply to message #233261] Wed, 25 April 2007 07:46 Go to previous message
simple_ora
Messages: 50
Registered: September 2006
Location: UAE
Member
hai
Did u check the parameters of ADD_LIST_ELEMENT...???
First parmeter is object id,the other is diplay value
and the last one is actual value ....which is using in your program

u can give it as follows
FOR Dp IN Dept_Cur LOOP
A := A + 1;
ADD_LIST_ELEMENT(p_List,A,dp.DName,dp.DName);
END LOOP;
END;

shefeeq

Previous Topic: Detail Record Disappear
Next Topic: comparision query
Goto Forum:
  


Current Time: Fri Dec 09 17:37:14 CST 2016

Total time taken to generate the page: 0.15962 seconds