SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2004
    Location
    Arizona
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ORA-00907: missing right parenthesis error in oracle

    i get this error quite often and i can never nail down exactly why i am getting it.

    in this query below i am getting it
    From cpr, cpr_person, cpr_object, cpr_product, cpr_customer
    *
    ERROR at line 5:
    ORA-00907: missing right parenthesis
    any help would be huge

    thanks


    set pagesize 0
    set heading off
    set linesize 1300
    select trim(cpr.cpr_num)||';'||trim(cpr.curr_state)||';'||trim(cpr_person.name)||';'||trim(cpr_product.prod_name)||';'||trim(prod_sname)
    ||';'||trim(cpr_product.prod_mgr)||';'||trim(cpr.tsu_case_num)||';'||trim(cpr.close_date)||';'||trim(cpr.enter_date)||';'||trim(cpr_customer.cust_id)
    ||';'||trim(cpr_customer.name)||';'||trim(cpr.cust_forum||';'||trim(cpr.full_descr)||';'||trim(cpr.abstract)
    ||';'||trim(cpr.intern_forum)||';'||trim(cpr.priority)||';'||trim(cpr.prob_type)||';'||trim(cpr.severity)
    From cpr, cpr_person, cpr_object, cpr_product, cpr_customer
    Where cpr_person.id_num=cpr.curr_owner
    And cpr_customer.cust_id=cpr.cust_id
    And cpr.cpr_num=cpr_object.cpr_num
    And cpr_object.object_id =cpr_product.prod_id;

  2. #2
    SitePoint Enthusiast
    Join Date
    Jan 2004
    Location
    Arizona
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ignore this was a simple syntax error

    Quote Originally Posted by AlexanderAZ
    i get this error quite often and i can never nail down exactly why i am getting it.

    in this query below i am getting it
    From cpr, cpr_person, cpr_object, cpr_product, cpr_customer
    *
    ERROR at line 5:
    ORA-00907: missing right parenthesis
    any help would be huge

    thanks


    set pagesize 0
    set heading off
    set linesize 1300
    select trim(cpr.cpr_num)||';'||trim(cpr.curr_state)||';'||trim(cpr_person.name)||';'||trim(cpr_product.prod_name)||';'||trim(prod_sname)
    ||';'||trim(cpr_product.prod_mgr)||';'||trim(cpr.tsu_case_num)||';'||trim(cpr.close_date)||';'||trim(cpr.enter_date)||';'||trim(cpr_customer.cust_id)
    ||';'||trim(cpr_customer.name)||';'||trim(cpr.cust_forum||';'||trim(cpr.full_descr)||';'||trim(cpr.abstract)
    ||';'||trim(cpr.intern_forum)||';'||trim(cpr.priority)||';'||trim(cpr.prob_type)||';'||trim(cpr.severity)
    From cpr, cpr_person, cpr_object, cpr_product, cpr_customer
    Where cpr_person.id_num=cpr.curr_owner
    And cpr_customer.cust_id=cpr.cust_id
    And cpr.cpr_num=cpr_object.cpr_num
    And cpr_object.object_id =cpr_product.prod_id;

    sorry i found the error i was missing right parenthesis after cpr.cust_forum
    doh
    sorry


Bookmarks

Posting Permissions

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