SQL & PL/SQL

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!

ORA-00907: missing right parenthesis--907

edy12Jul 28 2014 — edited Aug 12 2014

Hi All,

I am facing a peculiar situation. I am running a package iov_doi_link_pkg.main(takes 27 parameters) and we enter the parameter values related to our use. The main procedure also calls a previously created procedure IOV_XREF_CHECK_PRC(takes 25 parameters) out of which 22 parameters are same for both the procedures, this XREF check procedure uses dynamic sql queries and gets compiled without any errors.

When I am running the package iov_doi_link_pkg I am passing values for parameters and when i execute it in the dbms output i get the following error-ORA-00907: missing right parenthesis--907

and it also shows a portion of the dynamic query written in the xref_check procedure. I am lost and have no idea as to how to resolve the error.I am using PL-SQL Developer

Thanks..

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 9 2014

Added on Jul 28 2014

11 comments

1,880 views