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

What is pl/sql table? Why it is used?

1080

---

what is data manipulation language? : Sql dba

1071

---

List the various privileges that a user can grant to another user?

1092

---

What are the uses of sysdate and user keywords?

1151

---

Is ms sql is free?

1083

---

Do stored procedures prevent sql injection?

1015

---

What is lookup table in sql?

1094

---

What is the difference between truncate and drop statements?

1264

---

How to write a query to show the details of a student from students table whose

1063

---

What is an invalid partition table?

1067

---

What is cascade in sql?

1017

---

How do you update a sql procedure?

1092

---

How do I truncate a word?

1163

---

how does a local variable is defined using t-sql? : Transact sql

1060

---

How do I run sql profiler?

1118

---