3,491
社区成员
发帖
与我相关
我的任务
分享
SQL> create table t_nkls_jgfxjg(fxfz number,temp1 number,temp2 number,temp3 number,temp4 number,fxms varchar2(4000));
表已创建。
SQL> create or replace procedure USP_ZB_2321000ZB000048_CS ( as_fxpc in varchar2,
2 as_znfw in varchar2,
3 as_begin in varchar2,
4 as_end in varchar2,
5 err_code out number,
6 err_msg out varchar2)
7 is
8 begin
9 err_code:=0;
10 err_msg :='ok';
11 update t_nkls_jgfxjg jg
12 set jg.fxfz = (case when jg.temp3 <= 0.5 then 90
13 when (jg.temp3 > 0.5 and jg.temp3 <=0.9 ) then 70
14 when jg.temp3 > 0.9 then 50 end),
15 jg.fxms = '该纳税人[' || to_char(to_date('2012-01-01', 'yyyy-mm-dd'), 'yyyy') ||
16 '] 工资之处税收金额为[' || jg.temp2 || ']元,全员申报申报表中工资支出合计为[' ||
17 jg.temp1 || '],差额为[' || jg.temp4 || ']元';
18
19 update t_nkls_jgfxjg jg
20 set jg.fxfz = (case when jg.temp3 <= 0.5 then 90
21 when (jg.temp3 > 0.5 and jg.temp3 <=0.9 ) then 70
22 when jg.temp3 > 0.9 then 50 end),
23 jg.fxms = '该纳税人[' || to_char(to_date('2012-01-01', 'yyyy-mm-dd'), 'yyyy') ||
24 '] 工资之处税收金额为[' || jg.temp2 || ']元,全员申报申报表中工资支出合计为[' ||
25 jg.temp1 || '],差额为[' || jg.temp4 || ']元';
26 end USP_ZB_2321000ZB000048_CS;
27 /
过程已创建。
SQL>
实际测试了下,没啥问题啊select text from user_source
where type='PROCEDURE' and name='你的存储过程'
order by line;
||replace(sqlyj,'''','''''')||