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
- 11536 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many types of literals are available in pl sql?
What are tables and fields in the database?
Is primary key always clustered index?
How do I create a sql script?
What is the size of partition table?
Is sql database free?
what are string data types? : Sql dba
How many parts of a pl sql block are optional?
What does fetching a cursor do?
What is difference between hql and native sql?
Does inner join return duplicate rows?
Where can I learn sql for free?
what is the difference difference between procedure and packages
What is the difference between truncate and drop statements?
Explain ddl statements in pl/sql?
