Re: ORA-00907 missing right parenthesis problem

chris.damsgard_at_gmail.com 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'
AND object_name = 'GETGAPBUCKETSDEFN'
ORDER BY 1;

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org