insert into service_531 (servicecode,servicename,modulename, clientid,pricetime,pricenew,policy,dealaccount,dealtime)
select code,name,typeid,tempclientid,to_date(createdtime,'yyyy-mm-dd hh24:mi:ss'),to_number(price),policy,tempaccount,sysdate
from business
select code,name,typeid,tempclientid,to_date(createdtime,'yyyy-mm-dd hh24:mi:ss'),to_number(price),policy,tempaccount,sysdate
from business
create or replace procedure test as
tempclientid varchar2(10):='1x';
tempaccount varchar2(10):='6002';
begin
insert into table .... select ......;
end;
其中下面的select子句单独执行无问题(不带变量)create or replace procedure proc_busi2serv as
tempclientid varchar2(10):='1x';
tempaccount varchar2(10):='6002';
begin
insert into service_531 (servicecode,servicename,modulename, clientid,pricetime,pricenew,policy,dealaccount,dealtime)
select "code","name","typeid",tempclientid,to_date("createdtime",'yyyy-mm-dd hh24:mi:ss'),to_number("price"),"policy",tempaccount,sysdate
from business;
end;