Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11818 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
Does inner join remove duplicates?
how many values can the set function of mysql take? : Sql dba
What is the file extension for sql database?
What is the difference between partition and index?
What are all types of user defined functions?
How are functions and procedures called in PL/SQL?
How do I use google cloud in sql?
What is the basic structure of an sql?
What is sql trigger example?
How to connect a sql*plus session to an oracle server?
How do you declare a user-defined exception?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is a field in a database?
What is the source code of a program?
Explain scalar functions in sql?
