TCC: ORA-00939: too many arguments for function
(Doc ID 2476915.1)
Last updated on APRIL 28, 2023
Applies to:
Oracle Taleo Platform Cloud Service - Connect - Version 17.0 and laterInformation 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 |