Answer / ramesh

Nothing Happend package body created with no  errors.
Ex:
 create or replace package jan
 is
 procedure sp1;
 procedure sp2;
 end;
PACKAGE CREATED

 create or replace package body jan as
 procedure sp1 as
 begin
 dbms_output.put_line('hello');
 end;
 procedure sp2 as
 begin
 dbms_output.put_line('how are you');
 end;
 procedure sp3 as
 begin
 dbms_output.put_line('ok');
 end sp3;
 procedure sp4 as
 begin
 dbms_output.put_line('ramesh');
 end sp4;
 end;
PACKAGE BODY CREATED

Answer / 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

Answer / abhijit

If you are saying SP defined in package specification then compiler will give an error PLS-00103.

What are the cursor attributes used in PL/SQL ?

4 Answers  

---

Define the select into statement.

0 Answers  

---

how will be date change into string

4 Answers  

---

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

What is auto increment?

0 Answers  

---

What is latest version of sql?

0 Answers  

---

Can I learn sql in a week?

0 Answers  

---

What is sql partition function?

0 Answers  

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

0 Answers  

---

What is sql*loader?

0 Answers  

---

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

---

Explain raise_application_error.

0 Answers  

---