Entradas

Mostrando entradas de febrero 23, 2017

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(
    p_id in countries.country_id%type,
    p_nom in countries.country_name%type,
    p_regid in countries.region_id%type )
  is
  begin
    …