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
- 1 Answers
- 3574 Views
- I also Faced
- E-Mail Answers
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
what are the performance and scalability characteristics of mysql? : Sql dba
What is sql and explain its components?
what are tables and fields? : Sql dba
How can we avoid duplicating records in a query?
How do I run a pl sql program?
What is union?
what are the limitations of identity column? : Transact sql
What is percent sign in sql?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
what is the difference between cluster and non cluster index? : Sql dba
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is nosql vs sql?
Can a table contain multiple foreign key’s?
How delete a row in sql?
What is native sql query?
