Membuat Stored Procedure

1. Stored Procedure Untuk Proses Insert:

CREATE OR REPLACE PROCEDURE InsertKaryawan
(P_NIK IN VARCHAR2,
P_Nama IN VARCHAR2,
P_KodeDepartemen IN VARCHAR2,
P_Jabatan IN VARCHAR2,
P_Status I N VARCHAR2,
P_Agama IN VARCHAR2,
P_Alamat IN VARCHAR2)

AS
BEGIN
INSERT INTO KARYAWAN
VALUES
(P_NIK,
P_N ama
P_KodeDepartemen,
P_Jabatan,
P_Status,
P_Agama,
P_Alamat;
COMMIT;
END;

2. Stored Procedure Untuk Proses Update:

CREATE OR REPLACE PROCEDURE UpdateKaryawan
(P_NIK IN VARCHAR2,
P_Nama IN VARCHAR2,
P_KodeDepartemen IN VARCHAR2,
P_Jabatan IN VARCHAR2,
P_Status I N VARCHAR2,
P_Agama IN VARCHAR2,
P_Alamat IN VARCHAR2)

AS
BEGIN
UPDATE KARYAWAN SET
Nama = P_N ama
KodeDepartemen = P_KodeDepartemen,
Jabatan P_Jabatan,
Status = P_Status,
Agama = P_Agama,
Alamat = P_Alamat

WHERE NIK = P_NIK
COMMIT;
END;

3. Stored Procedure Untuk Proses Delete:

CREATE OR REPLACE PROCEDURE DeleteKaryawan
(P_NIK IN VARCHAR2,
P_Nama IN VARCHAR2)

AS
BEGIN
DELETE Karyawan
WHERE NIK = P_NIK;
END;