Application Engine Fatal SQL Error in PeopleCode
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";
0