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 |
If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is the difference between truncate and drop statements?
What are the different types of triggers?
What are the properties of a transaction?
How to rename a table?
What is cte?
What is the max nvarchar size?
What is compilation error in pl sql?
Does view store data in sql?
I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL
5 Answers Doyensys, Infosys, Metric Stream,
what are the methods using performance tunning in sql and pl/sql