jueves, 10 de abril de 2014

create package body in toad

To create a package body in toad, the simple way is copying the same structure of other package in the editor, so for example open 2 editors and compile, both of them structure and body, after that F5 to see the package created.

Here we have the STRUCTURE of the package:

CREATE OR REPLACE PACKAGE PHOSTOCLDS.SILVIQUIR_PKG AS
/******************************************************************************
   NAME:       SILVIQUIR_PKG
   PURPOSE:

   REVISIONS:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.0        10-04-2014      ext_squiroga       1. Created this package.
/******************************************************************************/
PROCEDURE PRC_INTFC002_BUSCAVALORESTIPO(TIPO IN VARCHAR2, TIPO_DOCU  IN VARCHAR2, ID_OPERADOR IN NUMBER , MODALIDAD IN VARCHAR2, ID_TIPO_CLIENTE OUT VARCHAR2, ID_TIPO_DOC OUT VARCHAR2, OPERADOR OUT VARCHAR2, ID_MODALIDAD OUT VARCHAR2);


END;
/

Here we have the BODY of the package:


CREATE OR REPLACE PACKAGE BODY PHOSTOCLDS.SILVIQUIR_PKG AS

PROCEDURE PRC_INTFC002_BUSCAVALORESTIPO
(TIPO IN VARCHAR2, TIPO_DOCU  IN VARCHAR2, ID_OPERADOR IN NUMBER , MODALIDAD IN VARCHAR2, ID_TIPO_CLIENTE OUT VARCHAR2, ID_TIPO_DOC OUT VARCHAR2, OPERADOR OUT VARCHAR2, ID_MODALIDAD OUT VARCHAR2)

 IS
 /******************************************************************************
   NAME:       PRC_INTFC002_BUSCAVALORESTIPO
   PURPOSE:  

   REVISIONS:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.0        03-04-2014   SILVIA QUIROGA      1. Created this procedure.

   NOTES:

   Automatically available Auto Replace Keywords:
      Object Name:     PRC_INTFC002_BUSCAVALORESTIPO
      Sysdate:         03-04-2014
      Date and Time:   03-04-2014, 16:07:33, and 03-04-2014 16:07:33
      Username:        ext_squiroga (set in TOAD Options, Procedure Editor)
      Table Name:       (set in the "New PL/SQL Object" dialog)

******************************************************************************/
BEGIN


END PRC_INTFC002_BUSCAVALORESTIPO;

END SILVIQUIR_PKG;
/


No hay comentarios: