n1/External/MEY/NL)
Sent by: Subject: stored procedure errors
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
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.
QOTD
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
CRE