这是存储过程:
CREATE OR REPLACE PROCEDURE "JKDB"."P_SCALE_INDEX" as
Sales VARCHAR2(200);
cursor c_job is select Enterprice_ID from jkdb.T_Scale;
begin
for c_row in c_job loop
Sales:=F_SCALE_INDEX(c_row.Enterprice_ID);
update jkdb.T_Scale set Scale_Sales=Sales where jkdb.T_Scale.Enterprice_ID=c_row.Enterprice_ID;
end loop;
end;
下面是调用的函数:CREATE OR REPLACE FUNCTION "JKDB"."F_SCALE_INDEX" (
ent_id in varchar2 --定义参数变量
) return varchar2 --定义返回的数据类型
Is
Result varchar2(64);
begin
select VALUE into Result from (select value from t_value where index_id='c8d857ce-f044-451f-9f8f-1568cde14777'and Enterprice_ID='''||ent_id||''' order by value_year desc) where rownum=1;
return(Result);
end;
CREATE OR REPLACE PROCEDURE "JKDB"."P_SCALE_INDEX" as
Sales VARCHAR2(200);
cursor c_job is select Enterprice_ID from jkdb.T_Scale;
begin
for c_row in c_job loop
Sales:=F_SCALE_INDEX(c_row.Enterprice_ID);
update jkdb.T_Scale set Scale_Sales=Sales where jkdb.T_Scale.Enterprice_ID=c_row.Enterprice_ID;
end loop;
end;
下面是调用的函数:CREATE OR REPLACE FUNCTION "JKDB"."F_SCALE_INDEX" (
ent_id in varchar2 --定义参数变量
) return varchar2 --定义返回的数据类型
Is
Result varchar2(64);
begin
select VALUE into Result from (select value from t_value where index_id='c8d857ce-f044-451f-9f8f-1568cde14777'and Enterprice_ID='''||ent_id||''' order by value_year desc) where rownum=1;
return(Result);
end;
此处用法错误,'''要改成''''