[Oracle]沒有參數Store Procedure

測試資料

select username,email from eflow.mem_geninf

建立資料表

CREATE TABLE yulin20101017(
    P_username varchar2(100),
    P_email varchar2(100)
)

建立Store Procedure

CREATE OR REPLACE PROCEDURE yulin_sp4
IS
BEGIN
INSERT INTO yulin20101017 (P_username,P_email)
select username,email from eflow.mem_geninf;
end;

執行Store Procedure

DECLARE
begin
yulin_sp4();
commit;
end;

select * from yulin20101017;

delete from  yulin20101017;

drop table yulin20101017;

DROP PROCEDURE yulin_sp4;