OraFAQ Forum: Forms » PLZ HELP ME ! URGENT !

Home » Developer & Programmer » Forms » PLZ HELP ME ! URGENT !

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

PLZ HELP ME ! URGENT ! [message #86134]

Thu, 02 September 2004 23:20

domingo
Messages: 54
Registered: June 2004

Member

Hi i am facing an unusual error

� I have�one �master and one details block.

� when one tries deleting a record from�detail block ,

� following error is generated.

frm-40508: oracle error
unable to insert record

Kindly guide me as why it is coming and how to get rd of it.

�� thnkx

�� DOMINGO

Report message to a moderator

Re: PLZ HELP ME ! URGENT ! [message #86135 is a reply to message #86134]

Fri, 03 September 2004 00:20

Sam
Messages: 255
Registered: April 2000

Senior Member

this is because the form trying to commit after you delete the record and maybe ur primary key of the header block has not been generated after u delete the detail level record...so unable to insert record error comes...
add the following code in key-delrec of detail block:-
IF :system.record_status <> 'NEW' THEN
begin
Delete_Record;
Raise Form_trigger_Failure;
end;

ELSE
CLEAR_RECORD;
END IF;
hope this helps.....

Report message to a moderator

Re: PLZ HELP ME ! URGENT ! [message #86136 is a reply to message #86135]

Fri, 03 September 2004 01:14

domingo
Messages: 54
Registered: June 2004

Member

yes that's true the error is shown when i try to commit the form .
But ur code is not working (the error is still there ).
Can u help me with any alternative solution
thnkx
domingo

Report message to a moderator

Re: PLZ HELP ME ! URGENT ! [message #86138 is a reply to message #86136]

Fri, 03 September 2004 01:39

Sam
Messages: 255
Registered: April 2000

Senior Member

unable to insert record error comes if null value is being assigned to a not null column...
plz try to see whether is happening....if yes then please assign the vale and then check...
even if it is not commiting, then just see the oracle sqlcode and sqlerrm it is throwing.....

Report message to a moderator

Re: PLZ HELP ME ! URGENT ! [message #86139 is a reply to message #86138]

Fri, 03 September 2004 01:51

argya
Messages: 7
Registered: August 2004

Junior Member

Domingo and SAM
I wll give you a rather stupid but working solution to this problem .
In the master block , Write a on_insert trigger
inside it write null;
and BINGO now run and the form will function properly.
regards
SHUBH

Report message to a moderator