This content has been marked as final. Show 5 replies
Have you tried this sql statement separately in sqlplus?
Is there any union clause after the select tatement.If so the union clause should contain the same number of columns as in the select clause
report is 11g or the DB is 11g?
the first query has 5 columns the other has 4
In your post, the bind variable :P2_REPORT_SEARCH has a carriage return before the word SEARCH. Make sure this is not the case in the report.