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;
/
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:
Publicar un comentario