您好, 欢迎来到 !    登录 | 注册 | | 设为首页 | 收藏本站

Oracle为什么在存在称为时间戳记的字段时创建触发器失败?

Oracle为什么在存在称为时间戳记的字段时创建触发器失败?

以下是有关Metalink的有关此(227615.1)摘录的注释:

# symptom: Creating Trigger fails
# symptom: Compiling a procedure fails
# symptom: ORA-06552: PL/sql: %s
# symptom: ORA-06553: PLS-%s: %s     
# symptom: PLS-320: the declaration of the type of this expression is incomplete or malformed
    # cause: One of the tables being references was created with a column name that is one of the datatypes (reserved key word). Even though the field is not referenced in the PL/sql sql statements, this error will still be produced.

    fix:

    Workaround:

    1. Rename the column to a non-reserved word.
    2. Create a view and alias the column to a different name.
Oracle 2022/1/1 18:48:18 有452人围观

撰写回答


你尚未登录,登录后可以

和开发者交流问题的细节

关注并接收问题和回答的更新提醒

参与内容的编辑和改进,让解决方法与时俱进

请先登录

推荐问题


联系我
置顶