| How to create LOV dyanamically at run time [message #290569] |
Sat, 29 December 2007 23:59  |
sachinbpl
Messages: 11
Registered: August 2007
|
Junior Member |
|
|
|
I am developing a form in which i want to dynamically populate LOV based on the value of atext item.When the text item changes the LOV values should change accordingly.Please give a sample code.Any help is highly appreciated.
|
|
|
|
|
|
| Re: How to create LOV dyanamically at run time [message #290573 is a reply to message #290571] |
Sun, 30 December 2007 00:20  |
sachinbpl
Messages: 11
Registered: August 2007
|
Junior Member |
|
|
Thanks Vamsi for the very prompt reply.I have following code in POST-TEXT-ITEM trigger of the text item:
DECLARE
rg_name VARCHAR2(20) := 'LEASE_RG';
rg_id RECORDGROUP;
err_code NUMBER;
con_num VARCHAR2(40) ;
--item_id ITEM := FIND_ITEM('XXCONTRACTS_ADDITIONAL_FIELDS.LEASE_NUMBER');
lov_id LOV;
qry VARCHAR2(1000);
BEGIN
con_num := :XXCONTRACTS_ADDITIONAL_FIELDS.CONTRACT_NUMBER;
qry :='SELECT to_char(lease_number) LEASE_NUMBER,to_char(lease_number)'||
' FROM xxcontracts_additional_fields '||
' WHERE contract_number LIKE ''%'||con_num||'%''';
MESSAGE('con_num= ' || con_num);
MESSAGE(qry);
lov_id := FIND_LOV('LEASE_NUMBER');
rg_id := FIND_GROUP(rg_name);
IF NOT ID_NULL(rg_id) THEN
DELETE_GROUP(rg_id);
END IF;
rg_id := CREATE_GROUP_FROM_QUERY(rg_name,qry);
DELETE_GROUP_ROW(rg_id, ALL_ROWS);
err_code := POPULATE_GROUP(rg_name);
--CLEAR_LIST(list_id);
-- POPULATE_LIST(list_id,rg_id);
SET_LOV_PROPERTY(lov_id,rg_name);
END;
I hv created an LOV LEASE_NUMBER and record group which selects all lease numbers to associate with the LOV bcoz if I dont hv RG associated with LOV it gives an error .This is giving me error FRM 40735POSt-TEXT_item trigger raised unhandled exception
ORA 06508
Please suggest where am I going wrong.ITs urgent I have to get form working immediately.Thanks
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
