Re: ORA-00907 missing right parenthesis problem

From: DA Morgan <>
Date: Thu, 03 Jan 2008 22:15:30 -0800
Message-ID: <> wrote:
> I figured out that if I put single quotes around the string, the
> missing right parenthesis error goes away.
> But, now it throws ORA-06553: PLS-306: wrong number or types of
> arguments in call
> I even get this error for a stored procedure that doesn't even take
> any parameters!
> call isi.net_gap_op_log.getgapbucketsdefn()

Call? Why? This syntax is valid in Oracle but the last time I saw it used was over a decade ago.

What is isi? Is it a schema name?
What is net_cgap_op_log? Is it a package name? What is getgapbucketsdefn? A stored procedure? Why aren't you providing the required parameters if you know it won't work without them?

Run the SQL statement and post the results:

SELECT position, argument_name, data_type, in_out FROM all_arguments
WHERE package_name = 'NET_CGAP_OP_LOG'

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Jan 04 2008 - 00:15:30 CST

Original text of this message