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
- 10965 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
What is sql performance tuning?
List and explain the different types of join clauses supported in ansi-standard sql?
Can you rollback after commit?
where are cookies actually stored on the hard disk? : Sql dba
Is sql better than excel?
What is delimiter sql?
Why function is used in sql?
Explain what is sql?
What does (+) mean in sql joins?
What is rollback?
what is try_catch block in procedure
How do I audit the sql sent to the server?
Explain the update statement in sql
In pl/sql, what is bulk binding, and when/how would it help performance?
How do I truncate a sql log file?
