|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
|
|||
|
|||
|
Packages
While creating a Package what is the purpose of creating spec. ?
Secondly, When I create a package it says Package created but with compilation errors. the code seem clear. Please advice what could be the problem. Thanks in advance. |
|
#2
|
|||
|
|||
|
A package is a schema object that groups logically related PL/SQL types, items, and subprograms. Packages usually have two parts, a specification and a body. The specification (spec for short) is the interface to your applications; it declares the types, variables, constants, exceptions, cursors, and subprograms available for use. The body fully defines
cursors and subprograms, and so implements the spec. Unlike subprograms, packages cannot be called, passed parameters or nested. Only packages provede function/procedure overloading. Regards |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Packages |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|