REP-0496: Internal error - Unable to parse query [message #380657] |
Mon, 12 January 2009 22:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
yasser2408
Messages: 1 Registered: January 2009 Location: OMAN
|
Junior Member |
|
|
I merged three queries to into 1 to solve the problem on speed
but as I paste my query on report query I got this error.
REP-0496: Internal error - Unable to parse query
select A.EMP_CODE,A.NAME_ENG1 ||' '||NAME_ENG2 ||' ' ||NAME_ENG3 "EMPLOYEE NAME",
A.NAME_ARB1 || ' ' || NAME_ARB2 || ' ' || NAME_ARB3 || ' '|| NAME_ARB4 NAME,
A.GROSS_SALARY,GROSS_SALARY + ANNUAL_INCREMENT "AFTER INCREMENT",B.GRADE_CODE,
CASE WHEN(A.GROSS_SALARY + 600) > B.BASIC_ENDING THEN B.BASIC_ENDING ELSE (A.GROSS_SALARY + 600) END AS NEW_SALARY,
B.GRADE_NAME
FROM
PER_EMP_MASTER A , PER_GRADES B, (SELECT GROUP_NAME, MIN (BASIC_STARTING), MAX(BASIC_ENDING) FROM PER_GRADES GROUP BY GROUP_NAME) D
WHERE
A.GRADE_CODE = B.GRADE_CODE
AND B.GROUP_NAME = D.GROUP_NAME
AND A.WORK_STATUS = 'Y'
ORDER BY 1
|
|
|
Re: REP-0496: Internal error - Unable to parse query [message #380680 is a reply to message #380657] |
Tue, 13 January 2009 00:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Here's a lucky guess (as you didn't provide much information about your working environment, such as Reports Builder version): your version doesn't support CASE. Try to rewrite this query using DECODE instead.
Another guess: inline view is not supported - in that case, create a view and use it in the FROM clause.
[Updated on: Tue, 13 January 2009 00:06] Report message to a moderator
|
|
|