This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: constructs, used in SQL functions, used by multiple users, provide IN,OUT, used without compilation. Package Properties: Package Spec. declares all public constructs of a package Package Body Defines all public and private constructs of a package Loads entire package into memory in one operation. Shared by many applications and users. Stored Program: Reduces disk retrieval, enforces data security, allows multiple access, Status of Database Objects: Valid: implies that the object is compiled and can be used when referenced. Invalid: implies that the object cannot be used when referenced. SELECT object_type, object_name FROM dba_objects WHERE object_type LIKE %PACKAGE BODY% and status=INVALID; Describe dbms_session; Troubleshooting invalid objects: The oracle server automatically recompiles the object the next time it is used. Database users force the Oracle server to compile an invalid dependent object....
View Full Document