As Ramesh said when creating the package body with procs that are not dec

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5
then What type of Error You will find????

Question Posted / ashokram s

3 Answers
11681 Views
Infosys, I also Faced
E-Mail Answers

Answer Posted / ashokram s

As Ramesh said
when creating the package body with procs that are not declared in specification, no error will be throwed. But when executing you cant execute the undeclared procs:

SQL> SET SERVEROUTPUT ON;
SQL> EXEC jan.sp1;
hello

PL/SQL procedure successfully completed.

SQL> EXEC jan.sp2;
how are you

PL/SQL procedure successfully completed.

SQL> EXEC jan.sp3;
BEGIN jan.sp3; END;

*
ERROR at line 1:
ORA-06550: line 1, column 11:
PLS-00302: component 'SP3' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is an alias command? : Sql dba

1120

What is number function in sql?

980

What is a sql instance vs database?

1121

What is the difference between sql and mysql?

1124

What is a constraint?

1029

how to enter numeric values as hex numbers? : Sql dba

1070

explain the delete statements in sql

1065

what is dbms? : Sql dba

1002

What is tuple in sql?

1087

How do I partition a table in sql?

1138

What are all the different types of indexes?

1152

What is function and procedure in pl sql?

1050

What is the difference between the implicit and explicit cursors?

1056

What is sql table?

978

What are the types of views in sql?

1103