Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00323: Subprogram Or Cursor....

850978Jun 9 2011 — edited Jun 9 2011
Hello All:

I am getting error PLS-00323 and not sure why.

I can compile the original package header / body with no errors, but as soon as I change a definition in both places, this error occurs on a line no where near my changes.

Original Package Header:
PROCEDURE clean_temp_data;

Original Package Body:
PROCEDURE clean_temp_data
IS

When I change them to this, I get error "PLS-00323: subprogram or cursor 'CLEAN_TEMP_DATA' is declared in a package specification and must be defined in the package body".

New Package Header:
PROCEDURE clean_temp_data(
p_Filename IN VARCHAR2,
p_EbizTranNo IN NUMBER);
New Package Body:
PROCEDURE clean_temp_data(
p_Filename IN VARCHAR2,
p_EbizTranNo IN NUMBER)
IS

I can see no spelling differences, parameter type differences, but the header compiles with no issues, but the package body gives me that errror on line 159, which has no relation to this procedure, as the procedure doesn't begin until line 1513.

What is causing this and how do I fix it? It makes no sense to me.

Thanks
Andy
This post has been answered by Peter Gjelstrup on Jun 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2011
Added on Jun 9 2011
2 comments
13,908 views