유저 생성

DROP PROCEDURE CREATE_USER_AND_BUSINESS;
COMMIT;

CREATE OR REPLACE PROCEDURE create_user_and_business(
    p_nickname IN VARCHAR2,
    p_email IN VARCHAR2,
    p_password IN VARCHAR2,
    p_birth_date IN DATE,
    p_gender IN VARCHAR2,
    p_registration_type IN VARCHAR2,
    p_user_type IN VARCHAR2,
    p_business_registration_number IN VARCHAR2,
    p_profile_url IN VARCHAR2,
    p_name_of_company IN VARCHAR2,
    p_name_of_representative IN VARCHAR2,
    p_date_of_business_commencement IN DATE,
    p_business_item IN VARCHAR2,
    p_connected_number IN VARCHAR2,
    p_fax_number IN VARCHAR2,
    p_zip_code IN VARCHAR2,
    p_business_address IN VARCHAR2
)
AS
   l_user_id users.id%TYPE;
BEGIN
    INSERT INTO users (
        nickname, email, password, birth_date, gender, registration_type,
        user_type, business_registration_number, profile_url
    ) VALUES (
        p_nickname, p_email, p_password, p_birth_date, p_gender,
        p_registration_type, p_user_type, p_business_registration_number,
        p_profile_url
    )
    RETURNING id INTO l_user_id;

    INSERT INTO business (
        name_of_company, name_of_representative, date_of_business_commencement,
        businessItem, connected_number, fax_number, zip_code, business_address, user_id
    ) VALUES (
        p_name_of_company, p_name_of_representative, p_date_of_business_commencement,
        p_business_item, p_connected_number, p_fax_number, p_zip_code, p_business_address,
        l_user_id
    );
END create_user_and_business;
/