How to debug invalid character in Data Template?
Getting the following error. The sql in the template works in Toad, but somehow when copied to Notepad, it introduced some invalid character(s). I had encountered the error before, but it was always due to apostrophes. Any other characters might cause the error?
CP main executing runProgram for oracle.apps.xdo.oa.cp.JCP4XDODataEngine
XDO Data Engine Version No: 5.6.3
Resp: 21540
Org ID : 84
Request ID: 34423929
All Parameters:
Data Template Code: XXSEESHRAUDIT
Data Template Application Short Name: XXSEES
Debug Flag: N
{}
Calling XDO Data Engine...
--SQLException
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
0