Hi All,

I am trying to customizing a form using custom.pll - pre-query trigger event is not working.

if (form_name = ‘xxxxxxx’ and block_name = ‘xxxxxxx’) then
if (event_name = ‘PRE-QUERY’) THEN
if name_in(block.item_name) is not null then
declare
v_trn_id varchar2(50);
v_decrypt varchar2(50);
begin
v_trn_id := name_in(block.item_name);
v_decrypt := package.function(v_trn_id);
copy(v_decrypt,block.item_name);
end;
end if;
end if;
end if;

Can any one Pls help

Thanks vb