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????
- 3 Answers
- 10961 Views
- Infosys, I also Faced
- E-Mail Answers
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
How many sql commands are there?
What is synchronized subquery?
How many joins in sql?
In what condition is it good to disable a trigger?
What is the difference between mdf and ndf files?
Is ms sql traffic encrypted?
What are sql indexes?
what is collation? : Sql dba
What is clause?
What is crud stand for?
What are the rules to be applied to nulls whilst doing comparisons?
Why truncate is used in sql?
what is the difference between char_length and length? : Sql dba
What is sp_helptext?
What are the most important characteristics of pl/sql?
