I have created one package with out procedures in package
specification and in package body i have used 2 procedures. is
it compile????
- 1 Answers
- 4080 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to connect asp pages to oracle servers?
How to delete all rows a table in oracle?
What are transaction isolation levels supported by oracle?
What is merge statement used for?
Is it possible to insert comments into sql statements return in the data model editor ?
What are the different types of trigger and explain its various uses and functions?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
select * from emp what happened internally when we write this query in the sql prompt?
How to write an inner join with the where clause in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to apply filtering criteria at group level in oracle?
Oracle General 
