Hi,
In FORMS 11g,
I'm trying to change the Record Group Query in a form, when a user clicks a button...
When Button Pressed:
Declare
err NUMBER;
value_selected BOOLEAN := FALSE;
BEGIN
err:=populate_group_with_query('RG_CAR_PREPAID',
'SELECT c.code, c.NAME, c.carrier_type_flag, c.org_id, a.csl_id,
a.service_level,
DECODE(:global.language, ''F'',NVL(a.service_name_fre,a.service_name_eng),
a.service_name_eng) service_name,
TO_CHAR (NVL (b.charge, 0), ''$9,999,999.99'') charge1,
DECODE (b.csl_id, NULL, 2, 1) sort, NVL(b.charge,0) charge, b.tariff_comment,
b.delivery_days, b.guaranteed, a.nmso, a.phone_number
FROM org c, (SELECT *
FROM csl
WHERE status = ''A''
AND (:v_shp_wsbl.dg_flag = ''N'' OR
dg_charge IS NOT NULL)) a, ctt b,
csl_ancillary csl_a
WHERE c.oty_code_org = ''CAR''
AND c.status = ''A''
AND c.transport_type = ''S''
AND c.org_id = a.org_id
AND a.csl_id = b.csl_id(+)
AND csl_a.ANCILLARY_NAME in (''REFRIGIRATOR'')
AND a.csl_id = csl_a.CSL_ID
ORDER BY sort, charge, c.code');
SET_LOV_PROPERTY('LOV_CAR', GROUP_NAME, 'RG_CAR_PREPAID');
value_selected := show_lov('LOV_CAR');
END;
But when the user clicks the button, i get this error message:
FRM-40502: ORACLE error: unable to read list of values.
WHY??
I populate the record group with the query, then I set that Record Group the the LOV...
Please help !
Thanks in advance,
Marc L