create or replace procedure P_WJ_LOG (DOING IN VARCHAR2(50)) is
LOG_ID NUMBER(12)
begin
SELECT ID INTO LOG_ID FROM WJ_LOG_ID;
INSERT INTO YJ_WJ_LOG(ID,LOG) VALUES(LOG_ID,DOING);
end P_WJ_LOG;
LOG_ID NUMBER(12)
begin
SELECT ID INTO LOG_ID FROM WJ_LOG_ID;
INSERT INTO YJ_WJ_LOG(ID,LOG) VALUES(LOG_ID,DOING);
end P_WJ_LOG;
改为
create or replace procedure P_WJ_LOG (DOING IN VARCHAR2) is
LOG_ID NUMBER(12);
begin
SELECT ID INTO LOG_ID FROM WJ_LOG_ID;
INSERT INTO YJ_WJ_LOG(ID,LOG) VALUES(LOG_ID,DOING);
end P_WJ_LOG;
create or replace procedure P_WJ_LOG (DOING IN VARCHAR2) is
LOG_ID NUMBER(12);
as
--LOG_ID NUMBER(12);
cursor t_sor is
select id from WJ_LOG_ID;
begin
for v_sor in t_sor loop
INSERT INTO YJ_WJ_LOG(ID,LOG) VALUES(v_sor.id,DOING);
end loop;
end P_WJ_LOG;