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


Please Help Members By Posting Answers For Below Questions

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2095


what is a constraint? Tell me about its various levels. : Sql dba

561


What is difference between db2 and sql?

530


What is self-join and what is the requirement of self-join?

632


What are crud methods?

551






What does partition by mean in sql?

513


Describe sql comments?

559


how to rename an existing table in mysql? : Sql dba

574


what is a cursor? : Sql dba

554


what is normalization? : Sql dba

561


What is a unique constraint?

608


how to calculate expressions with sql statements? : Sql dba

528


What is a primary key sql?

559


What are hotfixes and patches?

527


What is compute?

558