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 / 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
Why is sql better than hql?
What is sqlservr exe?
What is synchronized subquery?
What are the two types of cursors in pl sql?
How to select all records from the table?
Is there a 64 bit version of ssms?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
what are all different types of collation sensitivity? : Sql dba
What is before and after trigger?
Can we join more than 2 tables in sql?
What is the difference between partitioning and sharding?
What is the sql case statement?
What is server name sql?
How do I run a sql trace?
What is the most common sql injection tool?