以下是我測試的拋轉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;
範例程式
這個範例是所有關於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;
Oracle eBS (11.5.10.2) (13)