OraFAQ Forum: Forms » Cannot run..

Home » Developer & Programmer » Forms » Cannot run.. (

) 1 Vote

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

Cannot run.. [message #126484]

Tue, 05 July 2005 03:59

wanina
Messages: 2
Registered: July 2005

Junior Member

Can any one please help me to solve this error message..:
FRM-40508:ORACLE error: unable to INSERT record

Please tell me how to solve it asap.

zurina

Report message to a moderator

Re: Cannot run.. [message #126505 is a reply to message #126484]

Tue, 05 July 2005 05:22

Maaher
Messages: 7065
Registered: December 2001

Senior Member

If you get this error press SHIFT + F1 (show error) and look why the record cannot be inserted.

MHE

Report message to a moderator

Re: Cannot run.. [message #126602 is a reply to message #126505]

Tue, 05 July 2005 20:54

wanina
Messages: 2
Registered: July 2005

Junior Member

I've found it. Thankz. Cool

FRM-40508: ORACLE error: unable to INSERT record. Cause:  A fatal error occurred while trying to insert a record. The table associated with the current block of the form might not exist, your username might not have authority to perform the specified action on the table, or some other reason might have caused the fatal error.
Action:  Contact your DBA.
Level:  >25
Type:  Error

Report message to a moderator

Re: Cannot run.. [message #126715 is a reply to message #126602]

Wed, 06 July 2005 05:50

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I know, the FRM message actually tells you nothing. It's the server ORA message + the SQL statement you're interested in. In Client/Server Forms environment you can get that info by pressing shft+F1. In 3-tier environments I don't know the combination by heart.

MHE

Report message to a moderator

Re: Cannot run.. [message #126744 is a reply to message #126484]

Wed, 06 July 2005 08:02

Man Mohan Sharma
Messages: 35
Registered: October 2003

Member

Check the column name of base table is same as the field name and coumn name in prperty pallete for the same fiels. Also check is there any lack in insert previledge or size is full in the tablespace...
bye

Report message to a moderator

Previous Topic:	Hyperlink
Next Topic:	Doubt in forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:23:04 CDT 2024