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
- 10376 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
Does normalization improve performance?
How does rowid help in running a query faster?
What is primary key and unique key?
Explain about various levels of constraint.
What are the different ways to optimize a sql query?
Does inner join return duplicate rows?
Is it possible to sort a column using a column alias?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
How do I run sql profiler?
What are the advantages of pl sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Why indexing is needed?
How many commands are there in sql?
What is difference between rank () row_number () and dense_rank () in sql?
What is record data type?
