My Oracle Support Banner

E-DM: Data Mover Formatting Word Wrap Causes SQL Statements to Fail with ORA-00911: invalid character or ORA-00917: missing comma (Doc ID 2904903.1)

Last updated on DECEMBER 29, 2022

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.

Symptoms

When running long SQL statements on data mover, the process fails with either of the below error that is related to SQL formatting:


 

ERROR
-----------

 

 

The issue can be reproduced with the below steps:
1. Log into Data Mover.
2. Run a long SQL statement that will activate 'word wrapping' in the data mover command window.

 

 

Changes

 

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.