PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Application Engine Fatal SQL Error in PeopleCode

edited May 14, 2012 11:01AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered
 I am working on an Application Engine program to inactivate vendors from a CSV file attachment.  I am able to read the file and get the vendor IDs in the file to inactivate, but when the SQLExec runs it always fails with a Fatal SQL error.Any idea why? If I take the update statement and run it directly in SQL Plus it works.

my code is as follows: 

Local File &FILE;
Local SQL &SQL;
Local array of string &AS;
Local string &ATTACHSYSFILENAME = NI_VNDR_IN_AET.ATTACHSYSFILENAME;
Local number &update_count = 0;
Local string &VendorID;

Local string &fileSysPath = GetEnv("PS_SERVDIR") | "/files";

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center