Oracle Forms 编译时ORA-01445和 FRM-40501错误

Oracle Forms 编译时ORA-01445和 FRM-40501错误

ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

FRM-40501: ORACLE error: unable to reserve record for update or delete.

Forms开发中 编译后会遇到 上述问题 错误提示

解决办法

在当前的Data Block中 添加一个trigger on-lock 

目的是当操作当前行的数据时候进行锁定，防止别人进行修改

on-lock trigger中 填写 null; 即可

以下是on-lock trigger 介绍

Description

Fires whenever Form Builder would normally attempt to lock a row, such as when an operator presses a key to modify data in an item.  The trigger fires between the keypress and the display of the modified data.
Definition Level  form or block

Legal Commands

SELECT statements, unrestricted built-ins
Enter Query Mode  no

Usage Notes

n Use an On-Lock trigger to replace the default Form Builder processing for locking rows.  For example, for an application intended for use on a single-user system, use the On-Lock trigger to speed processing by bypassing all lock processing.  Also, use On-Lock when accessing a non-ORACLE data source directly, not by way of Open Gateway.

n When the On-Lock trigger fires as a result of an operator trying to modify data, the trigger fires only the first time the operator tries to modify an item in the record.  The trigger does not fire during subsequent modifications to items in the same record.  In other words, for every row that is to be locked, the trigger fires once.

n To perform the default Form Builder processing from this trigger, include a call to the LOCK_RECORD built-in.

n Use this trigger to lock underlying tables for non-updateable views.

Caution
In special circumstances, you may use the LOCK TABLE DML statement in an On-Lock trigger.  However, as this could result in other users being locked out of the table, please exercise caution and refer to the ORACLE RDMS Database Administrator's Guide before using LOCK TABLE.

On Failure

When the On-Lock trigger fails, the target record is not locked and Form Builder attempts to put the input focus on the current item.  If the current item cannot be entered for some reason, Form Builder attempts to put the input focus on the previous navigable item.

Fires In

Lock the Row

--刘轶鹤