帆软连接ORACLE19C报00911错误

原创 bjgzxx 2024-12-25

1、帆软用ojdbc8连接oracle19C

报错问题图片

下面是代码

SELECT
  CASE WHEN gs.name is NULL THEN fy.PRE_PAY_GS ELSE gs.name END 付款公司,
  fy.COST_GS 付款部门,
  TO_CHAR( fy.PAY_MONTH, 'YYYY/MM' ) 费用结算时间,
  CASE WHEN fy.FEE_TYPE='基建材料领用费' THEN CONCAT(fy.FEE_TYPE||'-',DEPAR) ELSE fy.FEE_TYPE END 费用类型,
  CASE WHEN IS_USA='否' THEN ROUND(fy.TOTAL_PRICE/usa.PAY_RATE,2) ELSE fy.TOTAL_PRICE END 金额,
  CASE WHEN fy.FEE_TYPE='基建材料领用费' THEN TO_CHAR(fy.PAY_MONTH,'YYYY/MM')||CONCAT(fy.FEE_TYPE||'-',DEPAR) ELSE TO_CHAR(fy.PAY_MONTH,'YYYY/MM')||fy.FEE_TYPE END 摘要,
  fy.COST_GS 立项号,
  pro.PRO_CONTENT 立项内容,
  fy.RECEIVE_DEPAR||fy.COST_GS 备注,
  fy.RECEIVE_DEPAR 施工单位
FROM
  INFRA_MATERIAL_USE fy
  LEFT JOIN PRO_NO_INFO pro ON fy.COST_GS = pro.pro_no
  LEFT JOIN USA_RATE usa ON usa.PAY_MONTH = fy.PAY_MONTH
  LEFT JOIN conpany gs ON fy.PRE_PAY_GS = gs.code
  WHERE
  fy.PAY_MONTH = TO_DATE('2024-12','YYYY-MM')复制

2、解决办法

字段别名用""括起来

如下：

SELECT
  CASE WHEN gs.name is NULL THEN fy.PRE_PAY_GS ELSE gs.name END "付款公司",
  fy.COST_GS "付款部门",
  TO_CHAR( fy.PAY_MONTH, 'YYYY/MM' ) "费用结算时间",
  CASE WHEN fy.FEE_TYPE='基建材料领用费' THEN CONCAT(fy.FEE_TYPE||'-',DEPAR) ELSE fy.FEE_TYPE END "费用类型",
  CASE WHEN IS_USA='否' THEN ROUND(fy.TOTAL_PRICE/usa.PAY_RATE,2) ELSE fy.TOTAL_PRICE END "金额",
  CASE WHEN fy.FEE_TYPE='基建材料领用费' THEN TO_CHAR(fy.PAY_MONTH,'YYYY/MM')||CONCAT(fy.FEE_TYPE||'-',DEPAR) ELSE TO_CHAR(fy.PAY_MONTH,'YYYY/MM')||fy.FEE_TYPE END "摘要",
  fy.COST_GS "立项号",
  pro.PRO_CONTENT "立项内容",
  fy.RECEIVE_DEPAR||fy.COST_GS "备注",
  fy.RECEIVE_DEPAR "施工单位"
FROM
  INFRA_MATERIAL_USE fy
  LEFT JOIN PRO_NO_INFO pro ON fy.COST_GS = pro.pro_no
  LEFT JOIN USA_RATE usa ON usa.PAY_MONTH = fy.PAY_MONTH
  LEFT JOIN conpany gs ON fy.PRE_PAY_GS = gs.code
  WHERE
  fy.PAY_MONTH = TO_DATE('2024-12','YYYY-MM')复制

问题解决

但是不知道为什么会出现这个问题。

oracle

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

reddey

3月前

oerr ora 911 00911, 00000, "invalid character" // *Cause: The identifier name started with an ASCII character other than a // letter or a number. After the first character of the identifier // name, ASCII characters are allowed including "$", "#" and "_". // Identifiers enclosed in double quotation marks may contain any // character other than a double quotation. Alternate quotation // marks (q'#...#') cannot use spaces, tabs, or carriage returns as // delimiters. For all other contexts, consult the SQL Language // Reference Manual. // *Action: Check the Oracle identifier naming convention. If you are // attempting to provide a password in the IDENTIFIED BY clause of // a CREATE USER or ALTER USER statement, then it is recommended to // always enclose the password in double quotation marks because // characters other than the double quotation are then allowed.

3月前

星星之火

3月前

oracle 11G没有问题，oracle 19C出现这个问题

3月前

reddey

3月前

@bjgzxx ，我在自己的19C上做了测试，没用双引号，也没有报错。

3月前

帆软连接ORACLE19C报00911错误

1、帆软用ojdbc8连接oracle19C

2、解决办法

评论

相关阅读