Missing Expression Error after migrating from Publisher 10g to Publisher 11g
Hi all,
This query for a report was working fine in Publisher 10g. It also works in SQLPlus, SQLDeveloper, etc.
When I try to edit the dataset in Publisher 11g, I get the missing expression error.
Any ideas? What does it not like? Case Stmt, Subquery, Something has changed in Publisher.
SELECT
A.IMPORT_RID ,
CASE WHEN (SELECT COUNT(1) FROM IMP_VALIDATION_RESULT WHERE IMPORT_RID =(:p_IMPORT_RID)) > 100 THEN A.IMPORT_FILE_NAME || ' (ONLY FIRST 100 ERRORS SHOWN)' ELSE A.IMPORT_FILE_NAME END AS IMPORT_FILE_NAME,
A.IMPORT_FILE_EXTENSION ,
A.IMPORT_FILE_TYPE ,
A.USER_RID ,