E-DM: While Exporting a Table in DataMover, Error - ORA-00936: Missing Expression (Doc ID 2273908.1)

Last updated on JUNE 05, 2017

Applies to:

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

Symptoms

When attempting to export a table in Datamover
the following error occurs.

ERROR
-----------------------
SQL Error. Error Position: 7 Return: 936 - ORA-00936: missing expression
SELECT ,, FROM PSCERTDEFN
Error: SQL execute error for PSCERTDEFN


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute in datamover:

SET LOG C:\Temp\export.log;
SET OUTPUT C:\Temp\data.dat;
EXPORT PSCERTDEFN;

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms