Skip to content

Oracle tool invocation with DML SQL raises error #2026

@duwenxin99

Description

@duwenxin99

Prerequisites

  • I've searched the current open issues
  • I've updated to the latest version of Toolbox

Toolbox version

toolbox version 0.21.0

Environment

Users encountered an “incorrect array type” error when running DML statements (insert, delete etc.). DQL queries worked fine (e.g select).
Log shows that the parameter is passed in as a string variable correctly, so the issue may happen when the driver is parsing a response from the Oracle server.

Client

No response

Expected Behavior

DML queries should be supported

Current Behavior

Image When using this configuration, the following error is raised: Image

Steps to reproduce?

  1. Set up tools.yaml with a oracle-sql or oracle-execute-sql tool that uses a DML statement.
  2. Invoke the tool

Additional Details

No response

Metadata

Metadata

Assignees

Labels

priority: p1Important issue which blocks shipping the next release. Will be fixed prior to next release.product: oracleOracletype: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions