Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2012
    Posts
    2

    Unanswered: ORA-00907: missing right parenthesis variable substition

    I the ORA-00907: missing right parenthesis error with the variable substition inside the test clause:
    select ('&&cbSubTeams' = 'true') from dual;
    please help

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    I wonder why you call the expression in SELECT clause "test clause". SQL WHERE clause is destined for filtering, which seems closer to the term you used.

    In Oracle SQL, you may only use expressions in SELECT clause. You are passing the comparison condition there.
    Both these language elements are described in SQL Language Reference Guide, which is available with other Oracle documentation e.g. online on http://tahiti.oracle.com/
    Please consult the one for your Oracle version.

    Without knowing, how is the query supposed to process, it is impossible to propose anything.
    And no, BOOLEAN data type (or any enumeration one holding values true and false) is not available in Oracle SQL.

  3. #3
    Join Date
    Mar 2012
    Posts
    2
    Thanks for the help.

Posting Permissions

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