Skip to content

QueryBuilder insert for Oracle failed #2434

@zephy358

Description

@zephy358

Issue type:

[ ] question
[X] bug report
[ ] feature request
[ ] documentation issue

Database system/driver:

[ ] cordova
[ ] mongodb
[ ] mssql
[ ] mysql / mariadb
[X] oracle
[ ] postgres
[ ] sqlite
[ ] sqljs
[ ] react-native

TypeORM version:

[X] latest
[ ] @next
[ ] 0.x.x (or put your version here)

Steps to reproduce or a small repository showing the problem:

await queryRunner.manager.createQueryBuilder()
          .insert()
          .into(Person)
          .values(people)
          .execute()

// { Error: ORA-00933: SQL command not properly ended errorNum: 933, offset: 140 }

Oracle seems doesn't support syntax like INSERT INTO xxx VALUES (value1, ...), (value2, ...)

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions