oracle forms 100125,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

--刘轶鹤