i declare 4 procedure in package specification but in package
body i write only 3 procedure. is it complie??//w
Answer Posted / rabindra nath das
i declare 4 procedure in package specification but in package
body i write only 3 procedure. is it complie??//w
------------------------------------------------------
Ans:-It will show you 'Warning: Package Body created with compilation errors.'
PLS-00323: subprogram or cursor'4thpackage name' is declared in a package specification and must be defined in the package body
because in package specification you are define 4 package
so you need to define 4 package under package body.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
what is a constraint? Tell me about its various levels. : Sql dba
What is difference between db2 and sql?
What is self-join and what is the requirement of self-join?
What are crud methods?
What does partition by mean in sql?
Describe sql comments?
how to rename an existing table in mysql? : Sql dba
what is a cursor? : Sql dba
what is normalization? : Sql dba
What is a unique constraint?
how to calculate expressions with sql statements? : Sql dba
What is a primary key sql?
What are hotfixes and patches?
What is compute?