| When Validate Record Error [message #402796] |
Tue, 12 May 2009 08:57  |
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 #403131 is a reply to message #402796] |
Wed, 13 May 2009 21:46  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
