重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 812|回复: 0
打印 上一主题 下一主题

ORA-26045: REF column string expects string arguments; found string.

[复制链接]
跳转到指定楼层
楼主
发表于 2016-9-2 09:01:43 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
ORA-26045: REF column string expects string arguments; found string.
Cause:
The number ofarguments for the REF column is incorrect.
Action: Specify the correctnumber of input arguments for REFs.
1. Unscoped system-generated REFs can have exactly 1 or 2 input arguments. a)It
has exactly 1 input argument (one for the OID value) if a fixed table name was
specified through OCI_DIRPATH_EXPR_REF_TBLNAME. b) It has exactly 2 input
arguments (one for the table name and one for the OID value) if a fixed tablename
was not specified through OCI_DIRPATH_EXPR_REF_TBLNAME.
2. Scoped system-generated REFs can have 1 or 2 input arguments. Because atable
name argument is not needed for a scoped ref, only 1 argument (OID value) is
expected. But if the table name argument is given, it's still accepted.
3. Scoped primary-key REFs with N columns in its primary-key OID can have N
or N+1 input arguments. Because a table name argument is not needed for a
scoped ref, only N arguments (making up the OID value) is expected. But if the
table name argument is given, it's still accepted.


分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2026-4-29 21:28 , Processed in 0.255389 second(s), 20 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表