OraFAQ Forum: Forms » Form Error

Home » Developer & Programmer » Forms » Form Error (winxp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Form Error [message #346187]

Sun, 07 September 2008 03:06

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?

Report message to a moderator

Re: Form Error [message #346188 is a reply to message #346187]

Sun, 07 September 2008 03:24

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

Report message to a moderator

Re: Form Error [message #346195 is a reply to message #346188]

Sun, 07 September 2008 04:06

blueF
Messages: 22
Registered: August 2008
Location: gulf

Junior Member

i can not display by using shift+F1 or help from browser??? please help

Report message to a moderator

Re: Form Error [message #346201 is a reply to message #346195]

Sun, 07 September 2008 04:32

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

Report message to a moderator

Re: Form Error [message #346203 is a reply to message #346201]

Sun, 07 September 2008 04:37

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?

Report message to a moderator

Re: Form Error [message #346204 is a reply to message #346203]

Sun, 07 September 2008 04:46

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

Report message to a moderator

Re: Form Error [message #346205 is a reply to message #346204]

Sun, 07 September 2008 05:09

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

Report message to a moderator

Re: Form Error [message #346257 is a reply to message #346205]

Sun, 07 September 2008 23:36

blueF
Messages: 22
Registered: August 2008
Location: gulf

Junior Member

thank you, i have solved the problem...

Report message to a moderator

Previous Topic:	Problem Regarding oracle forms installation
Next Topic:	error FRM-31634

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 12:58:07 CST 2025