I have created one package with out procedures in package
specification and in package body i have used 2 procedures. is
it compile????

Answer Posted / kumar swamy naidu

YES .if we create any PACKAGE with PROCEDURE on package Specification that's called GLOBAL PACKAGE.
If We Create Any PACKAGE with out procedure in package specification and it in package body that's called PRIVATE package.
it compile with out any error.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain oracle’s server parameter file.

659


How to use in conditions in oracle?

659


How to update values in a table in oracle?

660


What are the oracle built-in data types?

644


how do u setup a replication site?

1592






What is the difference between postgresql and oracle?

593


What is a parameter file in oracle?

644


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1784


What is proxy method?

623


what is a Nested Loop join?

1662


How to create tables for odbc connection testing?

577


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1726


What is an Oracle Instance?

763


Is there any function in oracle similar like group_concat of mysql?

639


What is the parameter mode that can be passed to a procedure?

665