CREATE OR REPLACE PACKAGE body Cux_HR_TEST_pkg IS
BEGIN
     Hr_Employee_Api.Create_Employee(p_Validate          => FALSE,
                                     p_Hire_Date         => to_date('06-06-2008', 'DD-MM-YYYY'),
                                     p_Business_Group_Id =>0,
                                     p_Last_Name         =>'乐1',
                                     p_Sex                =>'F',
                                     p_Person_Type_Id     =>6, 
                                     p_per_comments       =>'',
                                     p_Date_Employee_Data_Verified  => '', 
                                     p_Date_Of_Birth                =>to_date('06-06-1964', 'DD-MM-YYYY'),
                                     p_Email_Address                => 'nobody@localhost',
      p_Employee_Number              => '32350',
                                      p_Expense_Check_Send_To_Addres => '',
                                      p_First_Name                   => '乐2',
                                      p_Known_As                     => '乐3', --现用名
                                      p_Marital_Status               => '',
                                      p_Middle_Names                 => '乐4',
                                      p_Nationality                  => '',
                                      p_National_Identifier          => '342601198502230248',
                                      p_previous_last_name           => '乐5',
                                      p_Registered_Disabled_Flag => '',
                                      p_Title                    => '',
                                      p_vendor_id                    =>null,-----NUM
                                      p_work_telephone =>'',
                                        p_attribute_category => '',--EMP
                                     
                                      p_Name_Combination_Warning  => false,
                                      p_Assign_Payroll_Warning    => false,
                                      p_Orig_Hire_Warning         => false);
END;
end Cux_HR_TEST_pkg;我强行赋值去执行,但是在编译的时候出现  pls 00103 出现符号 "END"   的错误 ,自己在网上查询没有找到答案,求大侠们帮忙。这是一个定义导入EBS的HR 的包API。

解决方案 »

  1.   


    CREATE OR REPLACE PACKAGE body Cux_HR_TEST_pkg IS
    BEGIN
      Hr_Employee_Api.Create_Employee(p_Validate => FALSE,
      p_Hire_Date => to_date('06-06-2008', 'DD-MM-YYYY'),
      p_Business_Group_Id =>0,
      p_Last_Name =>'乐1',
      p_Sex =>'F',
      p_Person_Type_Id =>6,  
      p_per_comments =>'',
      p_Date_Employee_Data_Verified => '',  
      p_Date_Of_Birth =>to_date('06-06-1964', 'DD-MM-YYYY'),
      p_Email_Address => 'nobody@localhost',
    p_Employee_Number => '32350',
      p_Expense_Check_Send_To_Addres => '',
      p_First_Name => '乐2',
      p_Known_As => '乐3', --现用名
      p_Marital_Status => '',
      p_Middle_Names => '乐4',
      p_Nationality => '',
      p_National_Identifier => '342601198502230248',
      p_previous_last_name => '乐5',
      p_Registered_Disabled_Flag => '',
      p_Title => '',
      p_vendor_id =>null,-----NUM
      p_work_telephone =>'',
      p_attribute_category => '',--EMP
      
      p_Name_Combination_Warning => false,
      p_Assign_Payroll_Warning => false,
      p_Orig_Hire_Warning => false);
    end Cux_HR_TEST_pkg;
    --多个end,去掉就应可以了
      

  2.   

    看着提示,确实是一个begin对应两个end