Home » Developer & Programmer » Forms » When Validate Record Error (Forms 6i Windows XP)
When Validate Record Error [message #402796] Tue, 12 May 2009 08:57 Go to next message
edencharles
Messages: 3
Registered: May 2009
Location: Bangalore
Junior Member
When i change a record in the first block and try to come out i get an error saying
"When Validate Record Trigger raised unhandled exception ORA-06502 occured "
But the same error does'nt come when i m in the 2nd record
Can anyone guide me ...as to what the problem may be?
Re: When Validate Record Error [message #402799 is a reply to message #402796] Tue, 12 May 2009 09:18 Go to previous messageGo to next message
TonyJaa
Messages: 50
Registered: May 2009
Member
check your variables declarations compared to the type and lenght of the data.
Re: When Validate Record Error [message #402993 is a reply to message #402796] Wed, 13 May 2009 06:23 Go to previous messageGo to next message
edencharles
Messages: 3
Registered: May 2009
Location: Bangalore
Junior Member
Hi,

I chekced my variables and compared them..its correct
Re: When Validate Record Error [message #403000 is a reply to message #402796] Wed, 13 May 2009 07:02 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
why don't you post the code?
and descriptions of relevant tables.
Re: When Validate Record Error [message #403131 is a reply to message #402796] Wed, 13 May 2009 21:46 Go to previous messageGo to next message
edencharles
Messages: 3
Registered: May 2009
Location: Bangalore
Junior Member
PROCEDURE FCC_VALIDATE_RECORD
IS
BEGIN

IF NAME_IN('SYSTEM.RECORD_STATUS') <> 'QUERY' AND NAME_IN('parameter.prm_action_code') <> 'V'
THEN
IF pTabNav(NAME_IN(name_in('SYSTEM.CURSOR_BLOCK') || '.ROW_NUM')).action = 'E'
THEN
pTabNav(NAME_IN(name_in('SYSTEM.CURSOR_BLOCK') || '.ROW_NUM')).action := 'V';
END IF;

FCC_POST_RECORD;
END IF;
END FCC_VALIDATE_RECORD;

I can see its mainly bombing in NAME_IN('SYSTEM.RECORD_STATUS') <> 'QUERY' AND NAME_IN('parameter.prm_action_code')

[Updated on: Wed, 13 May 2009 22:11]

Report message to a moderator

Re: When Validate Record Error [message #403647 is a reply to message #403131] Sun, 17 May 2009 20:09 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Place 'message;pause;' pairs in your code to display the values of the various variables.

David
Previous Topic: form made by dev10g R1
Next Topic: Problem calling a report from that have a chart
Goto Forum:
  


Current Time: Sun Dec 04 12:25:24 CST 2016

Total time taken to generate the page: 0.11575 seconds