i declare 4 procedure in package specification but in package
body i write only 3 procedure. is it complie??//w

Answer Posted / ayan

Procedures that are defined in package spec are public
procedures but procedures those are in package body but not
in package spec are private procedure. we cannot call
private procedure using
package_name.private_procedure_name.Private procedure
should be called from any public procedure.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is tuple in sql?

547


What is sql scripting?

563


what is a control file ? : Sql dba

580


What is loop in pl sql?

576


What does dml mean?

547






What is package in pl sql?

579


Explain the difference between cursor declared in procedures and cursors declared in the package specification?

579


How do you update a table in sql?

519


how do you know the version of your mysql server? : Sql dba

508


how many columns can be used for creating index? : Sql dba

524


How is use pl and sql?

556


Who is the owner of mysql database?

553


What is data control language?

532


Is sql harder than python?

612


What has stored procedures in sql?

603