-- add_emp
--tworzymy pakiet
CREATE OR REPLACE SEQUENCE seq_addemp
START WITH 29
INCREMENT BY 1;
END seq_addemp;
/*
CREATE OR REPLACE PACKAGE pakiet
AS

    PROCEDURE add_emp(p_emp_last_name IN VARCHAR2,
    p_emp_first_name IN VARCHAR2,
    p_emp_userid IN VARCHAR2,
    p_emp_start_date IN DATE,
    p_emp_comments IN VARCHAR2,
    p_emp_manager_id IN NUMBER,
    p_emp_title IN VARCHAR2,
    p_emp_dept_id IN VARCHAR2,
    p_emp_salary IN NUMBER,
    p_emp_commission_pct IN NUMBER );
END pakiet;*/
/*CREATE OR REPLACE PACKAGE BODY pakiet
    IS
    PROCEDURE add_emp(p_emp_last_name IN VARCHAR2,p_emp_first_name IN VARCHAR2,p_emp_userid IN VARCHAR2,p_emp_start_date IN DATE,p_emp_comments IN VARCHAR2,p_emp_manager_id IN NUMBER,p_emp_title IN VARCHAR2,p_emp_dept_id IN VARCHAR2,p_emp_salary IN NUMBER,p_emp_commission_pct IN NUMBER)
    IS
    BEGIN
        INSERT INTO emp VALUES(seq_addemp.nextval,p_emp_last_name,p_emp_first_name,p_emp_userid,p_emp_start_date,p_emp_comments,p_emp_manager_id,p_emp_title,p_emp_dept_id,p_emp_salary,p_emp_commission_pct);

    END add_emp;
END pakiet;*/
EXECUTE pakiet.add_emp('Janek','Firaneusz','janek',TO_DATE('15-05-2022', 'dd-mm-yyyy'),'yes',1,'Stock Clerk',31,3111,10);