api-manager icon indicating copy to clipboard operation
api-manager copied to clipboard
verified publisher icon wso2

SQLSyntaxErrorException in Oracle versions prior to 23c

Open ashanhr opened this issue 1 year ago • 0 comments

Description

An SQLSyntaxErrorException occurs when using the CONCAT function in Oracle versions prior to 23c. The error is triggered when attempting to concatenate more than two arguments, which is not supported in these versions.

The exception thrown is: ORA-00909: invalid number of arguments

Error Trace: image

Steps to Reproduce

  1. Run the APIM with an Oracle version prior to 23c.
  2. Add deny policies.
  3. Execute the curl command to retrieve the deny policies by condition type and value.

Affected Component

APIM

Version

4.4.0

ashanhr avatar Oct 10 '24 06:10 ashanhr