> 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 18.104.22.168.0, VMS 22.214.171.124.0, VMS 126.96.36.199.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 188.8.131.52.0., WindowsNT Alpha
> 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
> Any help would be appreciated.
> CREATE OR REPLACE TRIGGER SCOTT.BIUE_DEPT
> BEFORE INSERT OR UPDATE
> ON SCOTT.DEPT
> REFERENCING OLD AS old NEW AS new
> FOR EACH ROW
> :NEW.dname := USER;
> 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...
< 1K Download