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????
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 14 Yes | 2 No |
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
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / abhijit
If you are saying SP defined in package specification then compiler will give an error PLS-00103.
Is This Answer Correct ? | 5 Yes | 4 No |
What are different types of functions in sql?
what is the forward decleration in packages?
What are the topics in pl sql?
What does select top 1 do in sql?
What does truncate mean in sql?
Can we create table inside stored procedure?
What are different categories of sql commands?
explain mysql aggregate functions. : Sql dba
What is clustered index in sql?
how to include comments in sql statements? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
What is set transaction?