package body "system.emp_package" has errors
就是调用的时候报这个错 求助T T
--创建包头--
create or replace package emp_package as
--声明存储过程,用于插入一条记录--
procedure my_proc(
lend_num varchar2,
lend_name varchar2,
lend_sex varchar2,
major varchar2
);
end emp_package;
--创建包体--
create or replace package body emp_package as
--存储过程的实现--
procedure my_proc(
lend_num varchar2,
lend_name varchar2,
ledn_sex varchar2,
major varchar2
) is
begin
insert into emp(lnum,lname,lsex,major)
values (lend_num,lend_name,lend_sex,major);
end my_proc;
end emp_package;
--这里是调用
begin
emp_package.my_proc('11', 'dsa', 'ewq', 'vc');
end;
------解决方案--------------------
建表语句:
SQL code
CREATE TABLE emp
(
lnum VARCHAR2(20),
lname VARCHAR2(20),
lsex VARCHAR2(20),
major VARCHAR2(20)
);