insert into SFZ_TEST_MANAGER_XG values ('abc1','bcd1','cde1'); insert into SFZ_TEST_MANAGER_XG values ('abc2','bcd2','cde2'); insert into SFZ_TEST_MANAGER_XG values ('abc3','bcd3','cde3'); insert into SFZ_TEST_MANAGER_XG values ('abc4','bcd4','cde4');
select * from SFZ_TEST_MANAGER_XG; select count(*) from SFZ_TEST_MANAGER_XG;
create or replace package sfz_obj as type sfz_cursor is ref cursor; procedure proc_sfz_proc_test(user_yxgh IN VARCHAR2,v_table out sfz_cursor); end sfz_obj;
DROP package sfz_obj;
create or replace package body sfz_obj as procedure proc_sfz_proc_test(user_yxgh IN VARCHAR2,v_table out sfz_cursor) is BEGIN INSERT INTO SFZ_TEMP_MANAGER_XG(YXGH,YGXM,POSITION_NAME) SELECT YXGH,YGXM,POSITION_NAME FROM SFZ_TEST_MANAGER_XG; --insert into SFZ_TEMP_MANAGER_XG values ('abc','bcd','cde'); --insert into SFZ_TEMP_MANAGER_XG values ('abc','bcd','cde'); --insert into SFZ_TEMP_MANAGER_XG values ('abc','bcd','cde'); --insert into SFZ_TEMP_MANAGER_XG values ('abc','bcd','cde'); open v_table for select * from SFZ_TEMP_MANAGER_XG; end proc_sfz_proc_test; end sfz_obj;