Rep-300: missing right parenthesis
438711Feb 17 2010 — edited Feb 17 2010Hi, after migrating from 6i to 10 g I am getting the above message when I am tryting to generate a report. the main query in the report is as follows:
select F.facility_id,
F.domestic_registration_nbr,
F.field_establishment_nbr,
F.primary_business_name
from facilities F
where F.ber_status_text = 'ACTIVE'
and F.facility_id ; in (select B1.facility_id
from facilities F1,
ber_action_history B1
where F1.facility_id = B1.facility_id
and F1.ber_status_text = 'ACTIVE'
&P_WHERE2
and B1.action_type_cd = 'PA')
&P_WHERE1
&P_ORDER
when I comment out the parameters the query works fine in Toad.
I have been stuck with this problem for days, any help will be g greatly appreciated.