: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by:Subject: stored procedure errors
[EMAIL PROTECTED
Hi Gurus,
I am creating a stored procedure using the below code. The procedure gets
created successfully. But while executing the procedure I am getting below
errors:
ERROR at line 1:
ORA-00907: missing right parenthesis
ORA-06512: at SCOTT.CREATE_RATEDOUTPUT, line 5
ORA-06512: at line 1
What is the extra comma doing before the CONSTRAINT RatedCDROut_PK ??
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
Title: RE: stored procedure errors
Ranganath,
Your dynamic statement is missing a paren somewhere, that's why it compiles without error.
Dig through your statement, you'll find where the paren is missing (it'll be within your quotes
HTH
Lisa Koivu
Headache Queen and DBA
Ft. Lauderdale, FL