by
> Hi!
> I try to upgrade my database from 7.3 to 8.04. Everything looks fine, but
> when i start to test my forms run into a problem, here is test case:
> On Oracle7 (tested on SCO 7.3.2.3.0, VMS 7.3.3.4.0, VMS 7.3.3.6.0):
> Connect scott/tiger. Insert new record and commit it. Update field dname to
> SCOTT (just retype SCOTT) and commit agaain. Database save record.
> On Oracle7 (tested on WindowsNT Intel 8.0.4.0.0., WindowsNT Alpha
> 8.0.4.1.0):
> Connect scott/tiger. Insert new record and commit it. Try to update field
> dname. Got an error: FRM-40501: Oracle error. unable to reserve record for
> update or delete. ORA-01410: invalid ROWID.
> Problem is in trigger on table DEPT, which change column DNAME. We have a
> lot of forms and tables with triggers and we don't won't to change that
> logic.
> Any help would be appreciated.
> Thanks
> Trigger:
> CREATE OR REPLACE TRIGGER SCOTT.BIUE_DEPT
> BEFORE INSERT OR UPDATE
> ON SCOTT.DEPT
> REFERENCING OLD AS old NEW AS new
> FOR EACH ROW
> DECLARE
> BEGIN
> :NEW.dname := USER;
> END;
> Form:
> --
> Boris
> -------------------------------
> Boris Oblak
> ABAKUS Kranj, d.o.o.
> Name: tcommit.fmb
> tcommit.fmb Type: unspecified type (application/octet-stream)
> Encoding: x-uuencode
for each base block,
after it, set Primary_Key=true on appropriate items...
|
sergey.vcf < 1K Download |