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
Why is sql*loader direct path so fast?
how to run 'mysql' commands from a batch file? : Sql dba
Is not equal in sql?
What are expressions?
What does joining a thread mean?
What is left join in postgresql?
Is left join inner or outer?
What is execution plan in sql?
how does a local variable is defined using t-sql? : Transact sql
Write a sql select query that only returns each name only once from a table?
What is pl sql script?
How do I turn a list into a table?
Show how functions and procedures are called in a pl/sql block.
Does execute immediate commit?
What is procedure explain with program?