Package y Procedures
Package y Procedures ****************** Este ejemplo es desarrollado con el esquema de HR de la base de datos Oracle Database 11g XE. /*Paquetes para un Modelo de BD Relacional*/ create or replace package pack_mante_pais is /*procedures*/ --registrar procedure usp_registrar_pais( p_id in countries.country_id%type, p_nom in countries.country_name%type, p_regid in countries.region_id%type ); --actualizar procedure usp_actualizar_pais( p_nom in countries.country_name%type, p_regid in countries.region_id%type, p_id in countries.country_id%type ); --eliminar procedure usp_eliminar_pais( p_id in countries.country_id%type ); --buscar procedure usp_buscar_pais( p_id in countries.country_id%type ); end pack_mante_pais; /*Cuerpo del Paquete*/ create or replace package body pack_mante_pais is procedure usp_registrar_pais( ...