以下是我測試的拋轉Script,供大家參考唷
範例程式
這個範例是所有關於Create_employee的Parameter都列出
如果你不需要傳入的值,參數可以不寫入...
但是 (Output Parameter)一定要輸出... 所以一定要有變數去接喔~~
精簡版如下:
/*-- Oracle HR API = New Employee--*/
DECLARE
v_validate BOOLEAN;
v_hire_date DATE:=sysdate;
v_business_group_id NUMBER:=1;
v_last_name VARCHAR2 ( 20 ):='文子';
v_sex VARCHAR2 ( 20 ):='M';
v_person_type_id NUMBER:=26;
v_per_comments VARCHAR2 ( 20 ):='Test02';
v_date_of_birth DATE:=to_date('19750101','yyyymmdd');
v_email_address VARCHAR2 ( 20 ):='kevin@vibo.com.tw';
v_employee_number VARCHAR2 ( 20 ):='0707112T'; -- Employee Number不可重複
v_first_name VARCHAR2 ( 20 ):='阮';
v_title VARCHAR2 ( 20 ):='MR.';
-- Output Parameter
v_party_id NUMBER;
v_person_id NUMBER;
v_assignment_id NUMBER;
v_per_object_version_number NUMBER;
v_asg_object_version_number NUMBER;
v_per_effective_start_date DATE;
v_per_effective_end_date DATE;
v_full_name VARCHAR2 ( 20 );
v_per_comment_id NUMBER;
v_assignment_sequence NUMBER;
v_assignment_number VARCHAR2 ( 20 );
v_name_combination_warning BOOLEAN;
v_assign_payroll_warning BOOLEAN;
v_orig_hire_warning BOOLEAN;
BEGIN
hr_employee_api.create_employee
( p_validate => v_validate,
p_hire_date => v_hire_date,
p_business_group_id => v_business_group_id,
p_last_name => v_last_name,
p_sex => v_sex,
p_person_type_id => v_person_type_id,
p_per_comments => v_per_comments,
p_date_of_birth => v_date_of_birth,
p_email_address => v_email_address,
p_employee_number => v_employee_number,
p_first_name => v_first_name,
p_title => v_title,
p_party_id => v_party_id,
p_person_id => v_person_id,
p_assignment_id => v_assignment_id,
p_per_object_version_number => v_per_object_version_number,
p_asg_object_version_number => v_asg_object_version_number,
p_per_effective_start_date => v_per_effective_start_date,
p_per_effective_end_date => v_per_effective_end_date,
p_full_name => v_full_name,
p_per_comment_id => v_per_comment_id,
p_assignment_sequence => v_assignment_sequence,
p_assignment_number => v_assignment_number,
p_name_combination_warning => v_name_combination_warning,
p_assign_payroll_warning => v_assign_payroll_warning,
p_orig_hire_warning => v_orig_hire_warning );
DBMS_OUTPUT.put_line ( 'INSERT' );
END;
範例程式
這個範例是所有關於Create_employee的Parameter都列出
如果你不需要傳入的值,參數可以不寫入...
但是 (Output Parameter)一定要輸出... 所以一定要有變數去接喔~~

精簡版如下:
/*-- Oracle HR API = New Employee--*/
DECLARE
v_validate BOOLEAN;
v_hire_date DATE:=sysdate;
v_business_group_id NUMBER:=1;
v_last_name VARCHAR2 ( 20 ):='文子';
v_sex VARCHAR2 ( 20 ):='M';
v_person_type_id NUMBER:=26;
v_per_comments VARCHAR2 ( 20 ):='Test02';
v_date_of_birth DATE:=to_date('19750101','yyyymmdd');
v_email_address VARCHAR2 ( 20 ):='kevin@vibo.com.tw';
v_employee_number VARCHAR2 ( 20 ):='0707112T'; -- Employee Number不可重複
v_first_name VARCHAR2 ( 20 ):='阮';
v_title VARCHAR2 ( 20 ):='MR.';
-- Output Parameter
v_party_id NUMBER;
v_person_id NUMBER;
v_assignment_id NUMBER;
v_per_object_version_number NUMBER;
v_asg_object_version_number NUMBER;
v_per_effective_start_date DATE;
v_per_effective_end_date DATE;
v_full_name VARCHAR2 ( 20 );
v_per_comment_id NUMBER;
v_assignment_sequence NUMBER;
v_assignment_number VARCHAR2 ( 20 );
v_name_combination_warning BOOLEAN;
v_assign_payroll_warning BOOLEAN;
v_orig_hire_warning BOOLEAN;
BEGIN
hr_employee_api.create_employee
( p_validate => v_validate,
p_hire_date => v_hire_date,
p_business_group_id => v_business_group_id,
p_last_name => v_last_name,
p_sex => v_sex,
p_person_type_id => v_person_type_id,
p_per_comments => v_per_comments,
p_date_of_birth => v_date_of_birth,
p_email_address => v_email_address,
p_employee_number => v_employee_number,
p_first_name => v_first_name,
p_title => v_title,
p_party_id => v_party_id,
p_person_id => v_person_id,
p_assignment_id => v_assignment_id,
p_per_object_version_number => v_per_object_version_number,
p_asg_object_version_number => v_asg_object_version_number,
p_per_effective_start_date => v_per_effective_start_date,
p_per_effective_end_date => v_per_effective_end_date,
p_full_name => v_full_name,
p_per_comment_id => v_per_comment_id,
p_assignment_sequence => v_assignment_sequence,
p_assignment_number => v_assignment_number,
p_name_combination_warning => v_name_combination_warning,
p_assign_payroll_warning => v_assign_payroll_warning,
p_orig_hire_warning => v_orig_hire_warning );
DBMS_OUTPUT.put_line ( 'INSERT' );
END;
全站熱搜