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。
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。
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,去掉就应可以了