oracle 创建表失败ORA-00903: invalid table name #1475

New Issue

vicvon · 2019-11-01T10:09:05Z

vicvon commented

2019-11-01 10:09:05 +00:00

在调用sync2时，会报ORA-00903错误，通过调试发现sql语句在表名和字段名上都加了中括号[]

类似于这种：
CREATE TABLE [Student] ([ID] NUMBER NOT NULL, [name] VARCHAR2(64) NOT
NULL, PRIMARY KEY ( [ID] ))

在调用sync2时，会报ORA-00903错误，通过调试发现sql语句在表名和字段名上都加了中括号[] 类似于这种： CREATE TABLE [Student] ([ID] NUMBER NOT NULL, [name] VARCHAR2(64) NOT NULL, PRIMARY KEY ( [ID] ))

lunny added the

kind

bug

label 2019-11-02 02:12:01 +00:00

lunny referenced this issue

2020-03-03 12:51:04 +00:00

oracle support doulbe quote but not square quote #1571

lunny added this to the 1.0.0 milestone 2020-03-03 12:51:25 +00:00

lunny closed this issue

2020-03-03 13:18:44 +00:00

dwa3092 commented

2020-03-31 14:14:12 +00:00

Having same issue, Oracle Inserts are erroring out with invalid table name,
I see the issue is closed, is it solved ?
Please redirect me if there is any solution is already available

Having same issue, Oracle Inserts are erroring out with invalid table name, I see the issue is closed, is it solved ? Please redirect me if there is any solution is already available

lunny commented

2020-04-01 01:25:35 +00:00

@dwadwa This issue should be fixed in v1.0.0 or above.

👍 1

tmalaher commented

2020-05-07 21:30:45 +00:00

See Pull Req #1674: replace the [ and ] quoting characterw with " and ".

Sign in to join this conversation.

No Milestone

No Assignees

4 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/xorm#1475