Re: Commit
From: Andy Hardy <Andrew.Hardy_at_BGTechnology.com>
Date: Wed, 4 Oct 2000 11:38:25 +0100
Message-ID: <8rf18s$sao$1_at_sun-cc204.lboro.ac.uk>
Date: Wed, 4 Oct 2000 11:38:25 +0100
Message-ID: <8rf18s$sao$1_at_sun-cc204.lboro.ac.uk>
The full error message is:
FRM-40508: ORACLE error: unable to INSERT record.
Cause: A fatal error occurred while Oracle Forms was trying to insert a record. The table associated with the current block of the form might not exist, your username might not have authority to perform the specified action on the table, or some other reason might have caused the fatal error.
Action: Contact your DBA.
Level: >25
Type: Error
[Quoted] It sounds like you are trying to insert duplicate rows. I'd suspect your master-detail set-up, perhaps you are changing values in one or the other blocks without intending to and causing Oracle to attempt to add the record?
Andy
-- Opinions are mine and may not reflect those of BG Technology Ltd Scott <swesley_at_student.ecu.edu.au> wrote in message news:39DAC849.11FBA28E_at_student.ecu.edu.au...Received on Wed Oct 04 2000 - 12:38:25 CEST
> G'day
>
> I am having a problem commiting updates or inserts to the database when
> there is a master-detail relation present.
> frm-40508 Unable to insert record
>
> This problem does not arise when all datablocks are control blocks (not
> connected to database), and insertions are done manually.
>
> I am using the commit command, although the same thing happens with
> commit_form;
>
> Does anyone have any suggestions?
>
> Thanks.
>