When executing original sql and alternatives (Batch Run), the following error is displayed for both the original sql and the alternatives.
"Error occurred: [932] (ORA-00932: inconsistent datatypes: expected NUMBER got LONG BINARY ORA-06512: at line 227"
It is a problem in the execution function to handle "LONG RAW" datatypes. This problem occurs only when the "Run on Server" option is used. Under this option, a script is created to run the SQL and this script helps shorten the overall time required for the execution as it fetches all records without sending them back to the client side (network travel is hence avoided). That script makes use of an Oracle package called DBMS_SQL and there is a problem in handling LONG RAW datatype there.
WORKAROUND 1
Change the SQL to avoid having any "LONG RAW" column in the select list. In your case, it is the CAL_FILE column to remove. Once optimized, you can changed the best alternative SQL back to contain the CAL_FILE column.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center