Home » Developer & Programmer » Forms » Form Error (winxp)
Form Error [message #346187] Sun, 07 September 2008 03:06 Go to next message
blueF
Messages: 22
Registered: August 2008
Location: gulf
Junior Member

When i created relation between 2 data blocks: one is child and other is parent, during insertion i got error which is form error ( frm-40508: oracle error unable to insert record ).
How should i solve this problem?
Re: Form Error [message #346188 is a reply to message #346187] Sun, 07 September 2008 03:24 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

hi,

Check the Forms Run Time Menu. Help --> Display Error

The Display Error key or menu option will invoke a dialog window that will contain the SQL INSERT statement that Forms was trying to execute when the FRM-40508 error occurred, and the actual ORACLE error that occurred.

regards,
Saadat Ahmad
Re: Form Error [message #346195 is a reply to message #346188] Sun, 07 September 2008 04:06 Go to previous messageGo to next message
blueF
Messages: 22
Registered: August 2008
Location: gulf
Junior Member

i can not display by using shift+F1 or help from browser??? please help
Re: Form Error [message #346201 is a reply to message #346195] Sun, 07 September 2008 04:32 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

The short key for Display Error in web forms is not Shift + F1. It's Alt+Ctrl+E.

regards,
Saadat Ahmad



Re: Form Error [message #346203 is a reply to message #346201] Sun, 07 September 2008 04:37 Go to previous messageGo to next message
blueF
Messages: 22
Registered: August 2008
Location: gulf
Junior Member

sorry man, it is nothing happened for poth shift+f1 and alt+ctrl+e.... what to do?
Re: Form Error [message #346204 is a reply to message #346203] Sun, 07 September 2008 04:46 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

Quote:
When i created relation between 2 data blocks: one is child and other is parent, during insertion i got error which is form error ( frm-40508: oracle error unable to insert record ).


How you get this error. If you get this error then you should be able to display the error also.

Check if you have created an extra item on any database block which is not database item but it's property is set as database item.

Which Oracle forms version are you using?
Are you showing Toolbar with your form?
Post a screen shot of your forms Run Time and the Error.

regards,
Saadat Ahmad
Re: Form Error [message #346205 is a reply to message #346204] Sun, 07 September 2008 05:09 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

Another option is:

Create On-Insert trigger at form level and write
display_error;

Run the form and then enter some data and try to save. It'll show you the error.

regards,
Saadat Ahmad
icon7.gif  Re: Form Error [message #346257 is a reply to message #346205] Sun, 07 September 2008 23:36 Go to previous message
blueF
Messages: 22
Registered: August 2008
Location: gulf
Junior Member

thank you, i have solved the problem...
Previous Topic: Problem Regarding oracle forms installation
Next Topic: error FRM-31634
Goto Forum:
  


Current Time: Wed Dec 07 16:18:12 CST 2016

Total time taken to generate the page: 0.09566 seconds