ORA-06553: PLS-306: 调用 'OGC_X' 时参数个数或类型错误

[Bobjoy]

错误内容

### Error querying database.  Cause: java.sql.SQLException: ORA-06553: PLS-306: 调用 'OGC_X' 时参数个数或类型错误

### The error may exist in xyz/yuanjilu/system/sysdic/dao/SysDictionaryDao.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select * from (    SELECT s.ID AS id, s.SYS_DIC_NAME AS name, s.PID AS pId,            to_char(x.SYS_DIC_SORT) as sort                 , s.IS_PARENT as isParent, s.SYS_DIC_DESCRIBE as bz,     s.SYS_DIC_KEY as key, s.SYS_DIC_VALUE as value, 'dic' as mark    from SYS_DICTIONARY s where  s.SYS_DIC_STATUS = '0'          and s.PID = ?            union all      SELECT x.ID AS id, x.SYS_DIC_NAME AS name, x.PID AS pId,                to_char(x.SYS_DIC_SORT) as sort                       , x.IS_PARENT as isParent, x.SYS_DIC_DESCRIBE as bz,       x.SYS_DIC_KEY as key, x.SYS_DIC_VALUE as value, 'dic' as mark      from SYS_DICTIONARY x where x.id = ? and x.SYS_DIC_STATUS = '0'      union all      SELECT b.ID AS id, b.SYS_DIC_TYPE_NAME AS name, b.SYS_DIC_TYPE_PID AS pId,       '1' as sort, 'true' as isParent, b.SYS_DIC_TYPE_DESCRIBE as bz,       '' as key, '' as value, 'dicType' as mark      from sys_dictionary_type b where b.SYS_DIC_TYPE_STATUS = '0' and b.id = ?              ) r   order by r.sort asc
### Cause: java.sql.SQLException: ORA-06553: PLS-306: 调用 'OGC_X' 时参数个数或类型错误

错误解释

X对象是MDSYS模式中的一个函数,“ogc_x”,所以当你说est.tipo_estatus =“X”而不是正确的est.tipo_estatus =’X’时它会被翻译(因为“”就像一个标识符所以“ X“与仅输入X相同”到est.tipo_estatus = mdsys.ogc_x,当然也失败了.