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-00201: identifier must be declared

ora_1978May 30 2008 — edited May 30 2008
CREATE OR REPLACE PACKAGE pa_terpaper_usa_ccaps_export AS
PROCEDURE pr_usa_ccaps_export(
i_num_prg_key IN NUMBER,
i_num_process_key IN NUMBER,
o_num_status OUT NUMBER);
END pa_terpaper_usa_ccaps_export;
/

I have defined the procedure in the package.

declare
o_num_stat number;
BEGIN
BUSEXP_OBJ.pa_terpaper_usa_ccaps_export.pr_usa_ccaps_export(15079,15746,o_num_stat);
END;
/



The procedure is compiling . But when I execute the above plsql procedure pr_usa_ccaps_export , I am getting error like

BUSEXP_OBJ.pa_terpaper_usa_ccaps_export.pr_usa_ccaps_export(15079,15746,o_num_st
at);
*
ERROR at line 4:
ORA-06550: line 4, column 1:
PLS-00201: identifier 'BUSEXP_OBJ.PA_TERPAPER_USA_CCAPS_EXPORT' must be
declared
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored

pls clarify
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2008
Added on May 30 2008
4 comments
47,436 views