Hello,

I am working on a SQL pass thru report but it errors out with SQLCode 907 - Missing right parenthesis.. The query runs fine in SQL Developer (Oracle DB) ... query does not run in WF...

I double checked the query, there is no missing parenthesis... I am not sure what is the cause of this error?

Please help - Thanks!

SELECT
..............
...............
,C.TERM_ID AS "TID"
,C.TRAN_DATE AS "TRANDATE"
,INITCAP(LOWER('MIS-USE')) AS "TRANTYPE"
,C.TRAN_ID AS "TRANID"
................
..............
FROM BROWSER.INFO_MASTER A
JOIN AEP.ALLOCATE_ALLOCATE B ON(B.MID = A.MID)
JOIN TXN.MIS_USE_FEE C ON(TRIM(C.MID) = B.MID)
WHERE C.TRAN_DATE >= '01-aug-10'
AND ............
AND...........

This message has been edited. Last edited by: Nova27,

Do you have a column in that query that is of type TIMESTAMP(0) WITH LOCAL TIME ZONE?

WebFOCUS does not handle those correctly. I usually CAST such fields to DATE, which WF does understand.

If that's not it, try adding trace statements around the passthru and SET XRETRIEVAL = OFF, so that you can see how WebFOCUS interprets the query.

Do you have any comments in your code? Things like --this is a comment after each line of SQL. That might need to be removed from your SQL.

Thank you guys for your responses..

I added the trace statements and it helped me see where the issue was..

Worked it out.. Thanks...