OraFAQ Forum: Forms » ora-04062 when-valida-item-trigger raise unhandled exception

Home » Developer & Programmer » Forms » ora-04062 when-valida-item-trigger raise unhandled exception (oracle,forms 6.0,windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-04062 when-valida-item-trigger raise unhandled exception [message #527139]

Sat, 15 October 2011 10:38

varun58
Messages: 1
Registered: October 2011
Location: hyderabad

Junior Member

I have Written this code in WHEN-VALIDATE-ITEM-TRIGGER on PO_DATE field

--------------------------------------------

if not( :PO_HEADER.PO_DATE IS NOT NULL ) then
:po_header.po_date := trunc(sysdate);
end if;

if trunc(:PO_HEADER.PO_DATE)>trunc(sysdate) then
displayerror.errmsg('PO date cannot be future date!');
raise form_trigger_failure;
end if;

begin
select fn_year into :po_header.fn_year
from fn_year_mst
where :po_header.po_date between from_date and to_date;
exception
when no_data_found then
displayerror.errmsg('Financial Year not found!');
raise form_trigger_failure;
end;

DECLARE
T_DATE DATE;
BEGIN

SELECT MAX(NVL(PO_DATE,sysdate)) INTO T_DATE
FROM po_header
WHERE comp_code = :Global.comp_code
and main_code = :global.po_main_code
and unit_code =:po_header.unit_code
and fn_year=:po_header.fn_year;
IF trunc(:po_header.PO_DATE) < trunc(T_DATE) THEN
DISP.ERRMSG('PO Date cannot be less than previous entry date : ' || to_char(t_date, 'dd-mm-yyyy') || ' !' );
end if;
END;

:po_header.po_no:=gen_po(:global.comp_code,:global.main_code,:po_header.unit_code,:po_header.voucher_code,:po_header.fn_year,:paramet er.vch_series);
----------------------------------------------------------

when i am navigating through po_DATE field in the form its showing the error that

WHEN-VALIDATE-ITEM-TRIGGER raised unhandled exception.

please suggest me in this regard.

Thanks in Advance

Report message to a moderator

Re: ora-04062 when-valida-item-trigger raise unhandled exception [message #527147 is a reply to message #527139]

Sat, 15 October 2011 12:37

cookiemonster
Messages: 13931
Registered: September 2008
Location: Rainy Manchester

Senior Member

It helps to look up error messages:

ORA-04062 string of string has been changed

Cause: Attempt to execute a stored procedure to serve an RPC stub which specifies a timestamp or signature that is different from the current timestamp/signature of the procedure.

Action: Recompile the caller in order to pick up the new timestamp.

Recompile the form (use compile all (shift+ctrl+k)) and try again.

Report message to a moderator

Re: ora-04062 when-valida-item-trigger raise unhandled exception [message #527209 is a reply to message #527147]

Mon, 17 October 2011 00:57

Baranor
Messages: 83
Registered: September 2011
Location: Netherlands

Member

Is also worth checking whether the DB runs on timestamp or signature valdidation. But indeed, recompile.

Report message to a moderator

Previous Topic:	Capture Key press in Oracle Forms
Next Topic:	how to consume sap xi pi web services or sap RFC with oracle 11g forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 11 07:40:24 CDT 2024