Re: ORA-00907 missing right parenthesis problem
Date: Thu, 03 Jan 2008 22:15:30 -0800
> 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
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.orgReceived on Fri Jan 04 2008 - 00:15:30 CST