| dymamic dropdown list problem [message #233261] |
Wed, 25 April 2007 07:37  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
