121234

CREATE OR REPLACE PROCEDURE InsertSalRecord (
p_empname IN VARCHAR2,
p_salary IN NUMBER,
p_dept_code IN VARCHAR2
)
AS
v_empid NUMBER;
BEGIN
-- Generate a new empid using a sequence or any appropriate method
SELECT Sal_seq.NEXTVAL -- Assuming you have a sequence named Sal_seq
INTO v_empid
FROM dual;

-- Insert the record into the Sal table
INSERT INTO Sal (empid, empname, salary, dept_code)
VALUES (v_empid, p_empname, p_salary, p_dept_code);

-- Commit the transaction
COMMIT;

-- Display success message
DBMS_OUTPUT.PUT_LINE('Record inserted successfully with empid: ' || v_empid);

EXCEPTION
WHEN OTHERS THEN
-- Handle exceptions
DBMS_OUTPUT.PUT_LINE('Error: ' || SQLERRM);
ROLLBACK;
END InsertSalRecord;
/