OraFAQ Forum: Forms » FRM-40735: ON-INSERT Trigger raised unhandled exception ORA-00984

Home » Developer & Programmer » Forms » FRM-40735: ON-INSERT Trigger raised unhandled exception ORA-00984 (Forms 6i)

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

FRM-40735: ON-INSERT Trigger raised unhandled exception ORA-00984 [message #310427]

Tue, 01 April 2008 04:26

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Hi friends,

I have two blocks. One is database block(empno,ename) and another one is non database block(empno,city) in a single canvas

I want to insert in my table database item empno and given city (non db item).

While i trying to insert i am getting error

FRM-40735: ON-INSERT Trigger raised unhandled exception ORA-00984

How i can insert?

Report message to a moderator

Re: FRM-40735: ON-INSERT Trigger raised unhandled exception ORA-00984 [message #310510 is a reply to message #310427]

Tue, 01 April 2008 08:09

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

>> oerr ora 984
00984, 00000, "column not allowed here"
// *Cause:
// *Action:

Report message to a moderator

Re: FRM-40735: ON-INSERT Trigger raised unhandled exception ORA-00984 [message #310620 is a reply to message #310427]

Tue, 01 April 2008 15:51

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Something's blocking mind-reading capabilities OraFAQ Forum Members get once they make 15 posts.

So, baby-steps is our way through it:
You have a form (fine). There are some blocks and items (so far, so good). You are trying to insert a record (cool). Oracle refuses to do that complaining that ON-INSERT trigger raised an unhandled exception (joy division says that this error code means that column is not allowed here).

As it's been more than 7 hours from the last message, does it mean that you managed to solve the problem? If not, I have an idea: break a spell and re-enable mind-reading by posting the code you used in the trigger. Doing so, we'd probably be able to suggest something more than just post error explanation (gee, even a child could find it on the net!) and suggest you NOT to do that (what you are doing at the moment) any more in order to avoid the error.

Report message to a moderator

Re: FRM-40735: ON-INSERT Trigger raised unhandled exception ORA-00984 [message #310653 is a reply to message #310427]

Tue, 01 April 2008 23:35

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Sorry,

We soloved that problem.

Report message to a moderator

Previous Topic:	How i get Last Record of Current Data Block using forms 6i
Next Topic:	update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 12:08:13 CDT 2025