3,491
社区成员
发帖
与我相关
我的任务
分享Oracle存储过程
不知道哪里写错了，其中AllSQL语句单独能执行，也可以查询出东西，报错误：
Warning: compiled but with compilation errors
Commit complete.
--员工提成设置表查询存储过程
--员工姓名模糊查询，或者查询所有
CREATE or replace procedure employdeduct_conditionfind
(
user_cursor out SYS_REFCURSOR
)
as
ALLSQL VARCHAR2(500);
begin
ALLSQL = 'select ed.id,
e.EMPLOYEENAME,
c.COMMODITYNAME,
ed.deducttype,
ed.ADDDATE,
ed.DEDUCT,
e.emptype,
e.branch,
EA.EMPLOYEENAME
from EMPLOYDEDUCT ed
inner join commodity c
on ed.commodityid = c.id
inner join EMPLOYEEINFO e
on ed.empid = e.id
inner join EMPLOYEEINFO ea
on ed.adminid = ea.id';
open user_cursor for ALLSQL;
end employdeduct_conditionfind;
commit;
Warning: compiled but with compilation errors
Commit complete.
--员工提成设置表查询存储过程
--员工姓名模糊查询，或者查询所有
CREATE or replace procedure employdeduct_conditionfind
(
user_cursor out SYS_REFCURSOR
)
as
ALLSQL VARCHAR2(500);
begin
ALLSQL = 'select ed.id,
e.EMPLOYEENAME,
c.COMMODITYNAME,
ed.deducttype,
ed.ADDDATE,
ed.DEDUCT,
e.emptype,
e.branch,
EA.EMPLOYEENAME
from EMPLOYDEDUCT ed
inner join commodity c
on ed.commodityid = c.id
inner join EMPLOYEEINFO e
on ed.empid = e.id
inner join EMPLOYEEINFO ea
on ed.adminid = ea.id';
open user_cursor for ALLSQL;
end employdeduct_conditionfind;
commit;
...全文
请发表友善的回复…
发表回复
GG_wg 2012-02-15
- 打赏
- 举报
查询语句要什么commit
select语句在过程里是select col1,col2 into v_col,col2 from table
select语句在过程里是select col1,col2 into v_col,col2 from table
秋雨飘落 2012-02-13
- 打赏
- 举报
end employdeduct_conditionfind;
commit;
commit;
quanhj 2012-02-13
- 打赏
- 举报
你这个需要commit么？
ICE-word 2012-02-13
- 打赏
- 举报
[Quote=引用 1 楼 hebeishimeng 的回复:]
SQL code
end employdeduct_conditionfind;
commit;
这俩句换一下位置
[/Quote]
正解，，先提交在结束。
SQL code
end employdeduct_conditionfind;
commit;
这俩句换一下位置
[/Quote]
正解，，先提交在结束。
raymonshi 2012-02-12
- 打赏
- 举报
end employdeduct_conditionfind;
commit;
这俩句换一下位置
