My Oracle Support Banner

TCC: ORA-00939: too many arguments for function (Doc ID 2476915.1)

Last updated on OCTOBER 11, 2019

Applies to:

Oracle Taleo Platform Cloud Service - Connect - Version 17.0 and later
Information in this document applies to any platform.

Symptoms

A TCC export produces the following Oracle database error in the response/results:

<Content xmlns="http://www.taleo.com/ws/integration/toolkit/2005/07">

<ExportErrors>

<Error>

<Code>ServerError</Code>

<Subcode>itk:ExportQueryExecutionError</Subcode>

<Reason>An error occurred during the query execution: ORA-00939: too many arguments for function</Reason>

<Detail>The unique identifier of the exception is 0d314c20-e0e4-11e8-9923-f4c3c4024118</Detail>

</Error>

</ExportErrors>

</Content>

 

Changes

 The export script has one or more projections that include the following custom function: <customFunction name="REGEXP_REPLACE">

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.