create or replace procedure ADD_REC4( emp_id number,emp_lastname varchar2,emp_email varchar2,emp_date date,emp_jobid varchar2,emp_salary number ) as begin insert into employees (EMPLOYEE_ID,LAST_NAME,EMAIL,HIRE_DATE,JOB_ID,SALARY) values (empid,emp_lastname,emp_email,emp_date,emp_jobid,emp_salary); exec ADD_REC4(1234,'AAA','BBB',sysdate,'1111',1000); end;
create or replace procedure ADD_REC4( emp_id number,emp_lastname varchar2,emp_email varchar2,emp_date date,emp_jobid varchar2,emp_salary number ) as begin insert into employees (EMPLOYEE_ID,LAST_NAME,EMAIL,HIRE_DATE,JOB_ID,SALARY) values (empid,emp_lastname,emp_email,emp_date,emp_jobid,emp_salary);
end; end ADD_REC4;
create or replace procedure add_rec4 ( emp_id number, emp_lastname varchar2, emp_mail varchar2, emp_date date, emp_jobid varchar2, emp_salary number) as begin declare test number; begin test := emp_id ; insert into employees(EMPLOYEE_ID,LAST_NAME,EMAIL,HIRE_DATE,JOB_ID,SALARY) values (test,emp_lastname,emp_mail,emp_date,emp_jobid,emp_salary); commit ; end ; end;SQL> exec add_rec4(1234,'AAA','BBB',sysdate,'1111',1000);PL/SQL 过程已成功完成。SQL> select *from employees;EMPLOYEE_ID LAST_NAME EMAIL HIRE_DATE JOB_ID SALARY ----------- ---------- ---------- ------------------- ---------- ---------- 1234 AAA BBB 2006-06-29 11:25:47 1111 1000
emp_id number,emp_lastname varchar2,emp_email varchar2,emp_date date,emp_jobid varchar2,emp_salary number
) as
begin
insert into employees (EMPLOYEE_ID,LAST_NAME,EMAIL,HIRE_DATE,JOB_ID,SALARY)
values (empid,emp_lastname,emp_email,emp_date,emp_jobid,emp_salary);
exec ADD_REC4(1234,'AAA','BBB',sysdate,'1111',1000);
end;
emp_id number,emp_lastname varchar2,emp_email varchar2,emp_date date,emp_jobid varchar2,emp_salary number
) as
begin
insert into employees (EMPLOYEE_ID,LAST_NAME,EMAIL,HIRE_DATE,JOB_ID,SALARY)
values (empid,emp_lastname,emp_email,emp_date,emp_jobid,emp_salary);
end;
end ADD_REC4;
emp_id number, emp_lastname varchar2, emp_mail varchar2,
emp_date date, emp_jobid varchar2, emp_salary number)
as begin
declare
test number;
begin
test := emp_id ;
insert into employees(EMPLOYEE_ID,LAST_NAME,EMAIL,HIRE_DATE,JOB_ID,SALARY)
values (test,emp_lastname,emp_mail,emp_date,emp_jobid,emp_salary);
commit ;
end ;
end;SQL> exec add_rec4(1234,'AAA','BBB',sysdate,'1111',1000);PL/SQL 过程已成功完成。SQL> select *from employees;EMPLOYEE_ID LAST_NAME EMAIL HIRE_DATE JOB_ID SALARY
----------- ---------- ---------- ------------------- ---------- ----------
1234 AAA BBB 2006-06-29 11:25:47 1111 1000
在执行: call ADD_REC4