Home » Developer & Programmer » Forms » FRM:40508 unable to insert record. (oracle 10g form window7)
FRM:40508 unable to insert record. [message #671462] Thu, 30 August 2018 06:44 Go to next message
ce.enggirfan@gmail.com
Messages: 1
Registered: August 2018
Junior Member
hi i am using WHEN-BUTTON-PRESSED into the Execute_Trigger('ON-INSERT'); but getting error FRM:40508 unable to insert record.
any one help this.
Re: FRM:40508 unable to insert record. [message #671463 is a reply to message #671462] Thu, 30 August 2018 07:29 Go to previous messageGo to next message
RaShi.Raj
Messages: 82
Registered: May 2014
Location: Bangalore
Member
You need to provide more details. You should also be getting corresponding ORA- message, what is that?. Not sure why you are forcing ON-INSERT trigger using 'EXECUTE_TRIGGER'.

This error appears if you are inserting/updating NULL values to mandatory columns.
Re: FRM:40508 unable to insert record. [message #671464 is a reply to message #671463] Thu, 30 August 2018 08:28 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
You should never need to use on-insert.
Why are you using a button at all rather than default forms processing?
Re: FRM:40508 unable to insert record. [message #672070 is a reply to message #671464] Mon, 01 October 2018 06:35 Go to previous message
Abhi@231225
Messages: 1
Registered: October 2018
Junior Member
You need to check the error use Ctrl+shift+E to display the errors
Previous Topic: FRM-40039- can not attch library while opening the fmb
Next Topic: ORA-01031: insufficient privileges in Forms
Goto Forum:
  


Current Time: Mon May 10 03:52:28 CDT 2021