Re: ORA-00907 missing right parenthesis problem

From: <chris.damsgard_at_gmail.com>
Date: Thu, 3 Jan 2008 14:55:51 -0800 (PST)
Message-ID: <28c3a76c-d78e-485b-9bd0-1372dfa4899a@d21g2000prf.googlegroups.com>


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() Received on Thu Jan 03 2008 - 16:55:51 CST

Original text of this message