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
What are sql built in functions?
Is sql a dbms?
What is foreign key and example?
What is user in sql?
What are the triggers associated with image items?
What are sql procedures?
What are tables in sql?
Is oracel sql developer written in java?
what is a view? : Sql dba
What is delete command in sql?
Can we join two tables without common column?
What is the use of sqlerrd 3?
What is sp_helptext?
What is the difference between numeric and autonumber?
What is the process of copying data from table a to table b?