ORA-00054 resource busy and acquire with NOWAIT specified 原因: The NOWAIT keyword forced a return to the command prompt because a resource was unavailable for a LOCK TABLE or SELECT FOR UPDATE command.
解决办法:Try the command after a few minutes or enter the command without the NOWAIT keyword.
解决办法:Try the command after a few minutes or enter the command without the NOWAIT keyword.
You must use the trigger in oracle when
you insert or update the table.
Otherwise the table will be locked when
the customers write the data into the table.
Action: Try the command after a few minutes or enter the command without the NOWAIT keyword. Copyright (C) 1995, Oracle Corporation
但是我所想要的回答是如下的情况:
例外情况名 Oracle错误代码
NO_DATA_FOUND ORA-01403
TOO_MANY_ROWS ORA-01427
INVALID_CURSOR ORA-01001
但是我所想要的回答是如下的情况:
例外情况名 Oracle错误代码
NO_DATA_FOUND ORA-01403
TOO_MANY_ROWS ORA-01427
INVALID_CURSOR ORA-01001
我所想要的是ORA-00054的这种例外情况名。
因为这个ORACLE并不是我所安装,手头上没有相应的安装软件,
购买资料也不方便,所有请教于大家。
再次感谢大家的热心回复,如果有心请再回复一张帖。
exception_name EXCEPTION;
PRAGMA EXCEPTION_INIT(exception_name, -54);
BEGIN
...
EXCEPTION
WHEN exception_name THEN
-- handle the error
END;