-- Copyright © Oracle Corporation 1995.  All Rights Reserved.
print 'Loading RESUMES table';
--
-- *** Store three rows needed for RESUMES Table:
--
SET TRANSACTION READ WRITE RESERVING RESUMES FOR SHARED WRITE;
DECLARE ONE INSERT ONLY TABLE CURSOR FOR SELECT EMPLOYEE_ID,RESUME FROM RESUMES;
DECLARE TWO INSERT ONLY LIST CURSOR FOR SELECT RESUME 
        WHERE CURRENT OF ONE;
OPEN ONE;
INSERT INTO CURSOR ONE (EMPLOYEE_ID) VALUES ('00164');
OPEN TWO;
INSERT INTO CURSOR TWO VALUES ('This is the resume for Alvin Toliver');
INSERT INTO CURSOR TWO VALUES ('Boston, MA');
INSERT INTO CURSOR TWO VALUES ('Oracle Corporation');
CLOSE TWO;
INSERT INTO CURSOR ONE (EMPLOYEE_ID) VALUES ('00165');
OPEN TWO;
INSERT INTO CURSOR TWO VALUES ('This is the resume for Terry Smith');
INSERT INTO CURSOR TWO VALUES ('Nashua, NH');
INSERT INTO CURSOR TWO VALUES ('Oracle Corporation');
CLOSE TWO;
INSERT INTO CURSOR ONE (EMPLOYEE_ID) VALUES ('00166');
OPEN TWO;
INSERT INTO CURSOR TWO VALUES ('This is the resume for Rick Dietrich');
INSERT INTO CURSOR TWO VALUES ('Hudson, NH');
INSERT INTO CURSOR TWO VALUES ('Oracle Corporation');
CLOSE TWO;
CLOSE ONE;
COMMIT;