procedure

Use procedure in oracle forms :

CREATE  PROCEDURE PRC_BED_WARD (p_ADMISSION_NO IN  IP_ADMISSION.ADMISSION_NO%TYPE,
  p_COMPANY_NO   IN  SC_SYSTEM_CONTROL.COMPANY_NO%TYPE,
     p_BED_NAME     OUT IP_BED.BED_NAME%TYPE,
      p_WARD_NAME    OUT IP_WARD.WARD_NAME%TYPE)

used in oracle forms :
just type procedure name in any block:

PRC_BED_WARD( v_addmission, :GLOBAL.G_COMPANY_NO, :CTRL_PATIENTINFO.BED_NAME, :CTRL_PATIENTINFO.WARD_NAME);
description :  here input two parameter and output two parameter ..