| FRM-40504 error message [message #87557] |
Sun, 16 January 2005 03:15  |
Arpit
Messages: 99
Registered: March 2001
|
Member |
|
|
Hi,
I'm getting the error message "FRM-40504: ORACLE error -- unable to execute a POST-CHANGE trigger" when tyring to enter or update a record via my FORMS3.0 application.
On display error I get:
Trigger statement in error: |
select param_value from appln_params where param_value = :1 and ( param_code = 'STAT_HOLID' or param_code = 'VAC_TAKEN' or param_code = 'SICK_LEAVE' or param_code = 'COMP_LEAVE' or param_code = 'MATERN_LV' or param_code = 'DISABILITY' or param_code = 'OT_TAKEN') Error: ORA-01722: invalid number
=======================================
I've tried to run the select statement to see if there are any null or expected then large value for parma_value in the appln_parmas table but there isn't any.
Can you please shed some light on this issue?
Thanks very much!
|
|
|
|
|
|
| Re: FRM-40504 error message [message #87559 is a reply to message #87558] |
Sun, 16 January 2005 03:46  |
Arpit
Messages: 99
Registered: March 2001
|
Member |
|
|
Sorry for that...I'won't be doing it the next time.
BTW, thanks very much for your help on my posted message.I'll try your suggestions and keep you posted.
Thx,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
