Error "Incorrect parameter count in the call to native function 'DECODE'" when executing a cross-connection query (4305345)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error "Incorrect parameter count in the call to native function 'DECODE'" when executing a cross-connection query
Description

When running a Cross Connection Query and using the function DECODE() the following error occurs:
"Incorrect parameter count in the call to native function 'DECODE'"
Sample cross query:
SELECT ADDRESS.COUNTRY
, DECODE(ADDRESS.COUNTRY, 'US', 'USA', 'OTHER') AS ChangeCountry
, REGION.REGION_ID
FROM
.
.
.
Resolution

WORKAROUND:
Use CASE statement in place of DECODE:
*** sample query using CASE

SELECT ADDRESS.COUNTRY,
case COUNTRY
WHEN 'US' THEN 'USA'
ELSE 'OTHER'
END AS ChangeCountry
.
.
.
STATUS:
In 4.2 and above, a message will now display to state that DECODE is not supported in cross-queries and to use CASE instead. The latest version can be downloaded here.
Defect ID

QAT-10739

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title