Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    42

    Exclamation Unanswered: Help: ORA-00936: missing expression

    Here is the query I am using:

    SELECT A.DIR_UID AS WHPROJECT,
    A.GRP_ID AS GRP_ID,
    A.ROL_ID AS ROL_ID,
    A.READONLY AS WHREADONLY,
    B.DESCRIPTION AS GRPDESC,
    C.DESCRIPTION AS ROLDESC ,
    ACT_FILTER,
    CAM_FILTER
    FROM WST_GRP B,
    WST_ROL C,
    WST_ACL A ,
    WHACTFILTER D
    WHERE A.DIR_UID=D.WHPROJECT(+)
    AND A.GRP_ID = D.GRP_ID(+)
    AND , WHCAMFILTER E
    WHERE A.DIR_UID=E.WHPROJECT(+)
    AND A.GRP_ID = E.GRP_ID(+)
    AND rtrim(A.DIR_UID)='a0004'
    AND rtrim(A.GRP_ID) = rtrim(B.GRP_ID)
    AND rtrim(C.ROL_ID) = rtrim(A.ROL_ID)
    ORDER BY nvl(B.DESCRIPTION, A.GRP_ID)

    Can someone please tell me why I am getting this error. I cannot see what the problem is.

    Thanks...

  2. #2
    Join Date
    Jan 2004
    Posts
    492
    You have 2 where clauses. It also looks like you have a table alias in the where clause.
    Oracle OCPI (Certified Practicing Idiot)

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    It seems that you didn't WANT to see it ...

    WHERE A.DIR_UID=D.WHPROJECT(+)
    AND A.GRP_ID = D.GRP_ID(+)
    AND , WHCAMFILTER E
    WHERE A.DIR_UID=E.WHPROJECT(+)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •