"Failed to execute the JScript Encode" error occurs when a Web application executes a dynamic SQL statement that is a string with colon (":") in it. For example, executing the following syntax triggers the error:
execute immediate "ALTER SESSION SET NLS_DATE_FORMAT ='rr/MM/DD
hh24:mi:ss'" using sqlca;
hh24:mi:ss'" using sqlca;This is an Appeon bug and will be fixed in the next version. If you use Appeon 6.0 for PowerBuilder, work around the issue by assigning the SQL statement string to a variable and dynamically executing the variable. For example:
string ls_sql
ls_sql = "ALTER SESSION SET NLS_DATE_FORMAT ='rr/MM/DD hh24:mi:ss'"
execute immediate :ls_sql using sqlca;
