| FRM-40504 oralce error message [message #64349] |
Sun, 16 January 2005 03:18  |
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 oralce error message [message #64350 is a reply to message #64349] |
Sun, 16 January 2005 03:39  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
My guess would be that the database-column param_value is of a character datatype and the forms-field is of a number-type.
If your query is coded in the post-change trigger, change it to 'param_value = to_char(:1)', else either change the datatype of the forms-field, or create a view containing only the parameters that have number-values and base your block on that.
(forms 3.0 and still detecting new bugs. wow.)
hth
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
