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????
Answer Posted / 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 |
Post New Answer View All Answers
Can we join same table in sql?
How to run pl/sql statements in sql*plus?
How does a trigger work?
what is union, minus and interact commands? : Sql dba
What is the purpose of normalization?
Write a sql select query that only returns each name only once from a table?
What is sql rowcount?
What is use of term?
Can you have a foreign key without a primary key?
What is inner join in sql?
Does view store data in sql?
How do you optimize a stored procedure in sql?
What is varchar used for?
Why indexing is needed?
How do I access sql anywhere database?