Tuesday, May 27, 2014

Oracle simple procedure for insert record

create or replace PROCEDURE                 USP_SAVE_CUSTOMERS
(
  P_CUSTOMERNAME IN VARCHAR2
, P_CONTACTPERSON IN VARCHAR2
, P_PHONE IN VARCHAR2
, P_EMAIL IN VARCHAR2
, P_ADDRESS1 IN VARCHAR2
, P_ADDRESS2 IN VARCHAR2
, P_CITY IN VARCHAR2
, P_STATE IN VARCHAR2
, P_ZIP IN VARCHAR2
, P_DESCRIPTION IN VARCHAR2
, P_ISACTIVE IN NUMBER
, P_CREATEDBY IN NUMBER
)
AS
BEGIN
 INSERT INTO TBL_CUSTOMER
 (
  CUSTOMERNAME,
  CONTACTPERSON,
  PHONE,
  EMAIL,
  ADDRESS1,
  ADDRESS2,
  CITY,
  STATE,
  ZIP,
  DESCRIPTION,
  STATUS,
  CREATEDBY,
  MODIFIEDDATE,
  MODIFIEDBY
 )
  VALUES
  (
  P_CUSTOMERNAME
, P_CONTACTPERSON
, P_PHONE
, P_EMAIL
, P_ADDRESS1
, P_ADDRESS2
, P_CITY
, P_STATE
, P_ZIP
, P_DESCRIPTION
, P_ISACTIVE
,P_CREATEDBY
,(TO_CHAR(SYSDATE))
,P_CREATEDBY
);
COMMIT ;
END USP_SAVE_CUSTOMERS;

No comments:

Post a Comment