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 mutating error?

699


explain advantages of myisam over innodb? : Sql dba

802


how to drop an existing index in mysql? : Sql dba

714


How do you use collections in procedure to return the resultset?

2000


What is nvarchar max in sql?

752






Is it mandatory for the primary key to be given a value when a new record is inserted?

931


Which command is used to delete a package?

773


What is primary key in db?

712


how to calculate the difference between two dates? : Sql dba

725


What are procedures used for?

703


What are sql constraints?

788


What is sql table?

690


What is the difference between microsoft sql and mysql?

709


Are stored procedures compiled?

678


Can we rollback delete command?

695