CREATEORREPLACEPROCEDUREaddemp(empnoemp.empno%type,enameemp.ename%type,jobcemp.job%type,mgrEMP.MGR%type,hiredateEMP.HIREDATE%type,salemp.sal%type,commemp.comm%type,deptnoemp.deptno%type)isBEGINinsertintoempvalues(empno,ename,jobc,hir

Question

CREATE OR REPLACE PROCEDURE add_emp(
empno emp.empno%type,
ename emp.ename%type,
jobc emp.job%type,
mgr EMP.MGR%type,
hiredate EMP.HIREDATE%type,
sal emp.sal%type,
comm emp.comm%type,
deptno emp.deptno%type)
is
BEGIN
insert into emp values (empno,ename,jobc,hiredate,mgr,sal,comm,depno);
END add_emp;
toad下创建简单存储过程,不懂了...
报错：ORA-00984:column not allowed here

Answer 1

搞不懂你为什么这么写

CREATE OR REPLACE PROCEDURE add_emp(
empno number,
ename varchar2,
job varchar2,
MGR varchar2,
HIREDATE varchar2,
sal number,
comm number,
deptno number) --以上都是定义变量
is
BEGIN
   insert into emp values (empno,ename,job,mgr,to_date(hiredate,'yyyy-mm-dd'),sal,comm,deptno); --要按照emp表字段顺序插入,对齐
   commit;--必须提交,否则不写入数据库
END add_emp;