以下是我測試的拋轉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;
arrow
arrow
    全站熱搜

    Somebaby 發表在 痞客邦 留言(1) 人氣()