If you have to declare procedure1,procedure2 in package
specification and if you have to declare
procedure1,procedure2 and procedure3 in package body? is it
compilation or not and execute or not? what type of error
is given please
Answer Posted / rajesh venati
No, error will occur, because you declared procedure1 and
procedure2 in specification, those are must and should be
define in the package body, other wise it raise an error.
We can declare any no of procedures in body, with out
declared in specification, those are accessible only local.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How do rank () and dense_rank () differ?
What does rownum mean in sql?
how to get @@error and @@rowcount at the same time? : Sql dba
what are the limitations of identity column? : Transact sql
What is trigger in sql? Explain
Does sql*plus also have a pl/sql engine?
What are sql indexes?
how to check myisam tables for errors? : Sql dba
What is crud diagram?
What is pivot in sql?
How does postgresql compare to "nosql"?
What are the types of views in sql?
What is an exception in PL/SQL? What are the two types of exceptions?
What is sql data?
What is difference between stored procedures and application procedures?