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;