Home » Developer & Programmer » Forms » FRM-99999 Error 408 Occurred
icon9.gif  FRM-99999 Error 408 Occurred [message #117987] Mon, 02 May 2005 08:05 Go to next message
lavallee_g
Messages: 22
Registered: May 2005
Location: Quebec
Junior Member
Hi,


Is there an easy way to get rid of error (FRM-99999 Error 408) , in Forms 6.0.8.22.1, DB 9.2.0.4.0. ????


The problem is caused by a constrain DEFERRABLE


ex:

ALTER TABLE FISTON ADD
CONSTRAINT FIST_PAPA_FK
FOREIGN KEY
(
PAPA_ID
)
REFERENCES PAPA
(
PAPA_ID
)
DEFERRABLE
INITIALLY DEFERRED
/

When you delete a child AND a parent then commit, forms only send the deletion of the parent instead of the child THEN the parent.

Looks like forms get lost in is logic who usualy commit the parent before the child.

What can I do?


Thanks

[Updated on: Mon, 02 May 2005 10:59]

Report message to a moderator

Re: FRM-99999 Error 408 Occurred [message #118078 is a reply to message #117987] Mon, 02 May 2005 23:31 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have a look at http://forums.oracle.com/forums/thread.jsp?forum=82&thread=214773&message=591412.

Does this solve your problem?

David

Report message to a moderator

icon7.gif  Re: FRM-99999 Error 408 Occurred [message #118165 is a reply to message #117987] Tue, 03 May 2005 07:33 Go to previous messageGo to next message
lavallee_g
Messages: 22
Registered: May 2005
Location: Quebec
Junior Member
Hi,
It may help but my problem is only with the delete. Instead of a deferred foreign key, a cascade delete may be used. The only problem with cascade delete is that is too powerfull. If not used with caution, it can delete A LOT of data.

Thanks for the hints, I'm already trapping my constraints message in a on-error, I can adjust it to supress FRM-99999.

Genevieve

[Updated on: Tue, 03 May 2005 07:35]

Report message to a moderator

Re: FRM-99999 Error 408 Occurred [message #118255 is a reply to message #117987] Tue, 03 May 2005 19:41 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Yes it can delete a lot of data, but only data that is related. If you DON'T delete the subordinate data then I think that the parent delete will fail as there are subordinate children. If you have relationships then the database has a binary decision to make "are all children deleted - yes or no".

<sarcasm>Try this for a brilliant idea. Never delete!</sarcasm>

In MANY corporate system there is NO delete facility within the online application. Deletions are either done through an archiving procedure or not at all, they just grow.

David

Report message to a moderator

icon7.gif  Re: FRM-99999 Error 408 Occurred [message #118376 is a reply to message #118255] Wed, 04 May 2005 15:18 Go to previous messageGo to next message
lavallee_g
Messages: 22
Registered: May 2005
Location: Quebec
Junior Member
With over 1.5 millions records in a table, we need a delete functionnality

With that many records, a cascade delete is scary Smile

[Updated on: Wed, 04 May 2005 15:20]

Report message to a moderator

Re: FRM-99999 Error 408 Occurred [message #118397 is a reply to message #117987] Wed, 04 May 2005 20:21 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Make sure your rollback areas are big enough and only delete 1 parent record at a time. Oracle WILL do it correctly.

David

Report message to a moderator

Re: FRM-99999 Error 408 Occurred [message #118464 is a reply to message #118397] Thu, 05 May 2005 07:40 Go to previous messageGo to next message
lavallee_g
Messages: 22
Registered: May 2005
Location: Quebec
Junior Member
The rollback segment is big enought trust me Smile

The delete works perfectly when I delete directly in the database, but form does not work with deletion of child, parent then commit. I veryfied my session and only the delete of the parent is sent to the database.

Finaly, I change the behavior of my screen and bypassed the problem.

Genevieve

Report message to a moderator

Re: FRM-99999 Error 408 Occurred [message #118568 is a reply to message #117987] Thu, 05 May 2005 20:52 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
My apologies. I just reread the doco and the cascade only works for the detail blocks that have been defined in the form. Therefore, you would have to define a detail block and relationship to ALL of the subordinate tables to get the delete of the parent to automatically delete the children.

Suggestion: Create a pre-delete trigger for your parent table that contains a 'delete from child_a where parent = :par_blk.id' for each of the child tables. This should probably be a procedure in your database so that it can be maintained independantly from the form.

David

Report message to a moderator

Previous Topic: help plzzzzzzzzz!!!!!!!!!!!!!1
Next Topic: Check how oracle developer connect with ms asccess or sqlserver(Very intresting)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 05:02:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.