Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rep-300: missing right parenthesis

438711Feb 17 2010 — edited Feb 17 2010
Hi, 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.
This post has been answered by DC on Feb 17 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2010
Added on Feb 17 2010
10 comments
1,826 views