CREATE TABLE ORGANIZATION_DETAILS
(ORG_KEY NUMBER,
ORG_NAME VARCHAR2(20)
)

INSERT INTO ORGANIZATION_DETAILS VALUES 
  (1,'ORG_A' 
  )

INSERT INTO ORGANIZATION_DETAILS VALUES 
  (2,'ORG_B' 
  )

INSERT INTO ORGANIZATION_DETAILS VALUES 
  (3,'ORG_C' 
  )

SELECT * FROM ORGANIZATION_DETAILS

CREATE OR REPLACE PROCEDURE PROC_UPDATE_ORG_DETAILS( 
    in_org_key      NUMBER, 
    in_new_org_name VARCHAR2) 
AS 
BEGIN 
  UPDATE ORGANIZATION_DETAILS 
  SET ORG_NAME  = in_new_org_name 
  WHERE ORG_KEY = in_org_key; 
  COMMIT; 
END;

EXEC PROC_UPDATE_ORG_DETAILS(1,'NEW_ORG_A')

select * from organization_details