create or replace procedure insert_abc( p_id in integer, p_val1 in varchar2, p_val2 in varchar2 ) as beginselect sell_term_id from cp_205_station_power_tab WHERE END_DRAW_TIME> SYSDATE if sql%rowcount=0 then insert into CP_PUSH_BUFFER_TAB (SN_ID, MSG_ID,) values ('ADAD01073004005201458051553', '0');end if; begin end if; commit; end ;// 这样写是否正确?
p_id in integer,
p_val1 in varchar2,
p_val2 in varchar2
)
as
beginselect sell_term_id from cp_205_station_power_tab WHERE END_DRAW_TIME> SYSDATE if sql%rowcount=0 then
insert into CP_PUSH_BUFFER_TAB (SN_ID, MSG_ID,)
values ('ADAD01073004005201458051553', '0');end if;
begin
end if;
commit;
end ;//
这样写是否正确?