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

Is grant a ddl statement?

451


What is the difference between Union and Union all. Which is faster.

844


what are the difference between clustered and a non-clustered index? : Sql dba

526


where are cookies actually stored on the hard disk? : Sql dba

578


What are the advantages of sql?

558






Why do we use cursors?

509


What are the two types of periodical indexes?

505


What is difference between sql function and stored procedure?

504


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

614


how can we know the count/number of elements of an array? : Sql dba

573


How to add new employee details in an employee_details table with the following details

643


What are instead of triggers?

624


What is difference between hql and native sql?

577


What are sql functions? Describe the different types of sql functions?

555


How to call shell script from pl sql procedure?

625