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

Why is sql better than hql?

970

---

What is sqlservr exe?

964

---

What is synchronized subquery?

1140

---

What are the two types of cursors in pl sql?

1058

---

How to select all records from the table?

1115

---

Is there a 64 bit version of ssms?

942

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1041

---

what are all different types of collation sensitivity? : Sql dba

966

---

What is before and after trigger?

932

---

Can we join more than 2 tables in sql?

1000

---

What is the difference between partitioning and sharding?

989

---

What is the sql case statement?

978

---

What is server name sql?

1121

---

How do I run a sql trace?

946

---

What is the most common sql injection tool?

1026

---