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 |
How do you create an update query?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What do you mean by stored procedures?
What does trigger mean in psychology?
Is sql developer case sensitive?
Does pl sql work in mysql?
What are the types of triggers in sql?
How long does it take to learn pl sql?
What is sql server and ase?
what is global variable in pl/sql
----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?