Home » Developer & Programmer » Forms » FRM-40509 ORA-02292:
FRM-40509 ORA-02292: [message #236084] Wed, 09 May 2007 00:32 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
What is the best command for clear the block.

Actual I am creating duplicate record but when I save this record it gives the error FRM-40509 and when I see in detail it is ORA-02292.

when I press duplicate button I write in starting that clear_block and fetch the data through Query. but it gives the error that first you delete you record what is the solution that clear all data in table and make duplicate.

When I commit shows this msg in back.

ORA-02292: integrity constraint (KAMRAN.COST_NO_FK1) violated - child record found

Note: I am not deleting any record just copying/duplicate.

[Updated on: Wed, 09 May 2007 01:37]

Report message to a moderator

Re: FRM-40509 ORA-02292: [message #236177 is a reply to message #236084] Wed, 09 May 2007 04:24 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It would help if you post real trigger code, not describing it.

Because, if Oracle says that you are attempting to delete a perent record and it refuses to do so because child record exists, I, somehow, believe it.
Previous Topic: how to use HOST command
Next Topic: Query condition
Goto Forum:
  


Current Time: Sat Dec 03 14:17:55 CST 2016

Total time taken to generate the page: 0.09869 seconds