Home » Developer & Programmer » Forms » FRM-40735: ON-INSERT Trigger raised unhandled exception ORA-00984 (Forms 6i)
FRM-40735: ON-INSERT Trigger raised unhandled exception ORA-00984 [message #310427] Tue, 01 April 2008 04:26 Go to next message
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?
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 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
>> oerr ora 984
00984, 00000, "column not allowed here"
// *Cause:
// *Action:

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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
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 Go to previous message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Sorry,

We soloved that problem.
Previous Topic: How i get Last Record of Current Data Block using forms 6i
Next Topic: Do You Want to Save...
Goto Forum:
  


Current Time: Sun Dec 11 02:15:38 CST 2016

Total time taken to generate the page: 0.09708 seconds