Basic HTML version of Foils prepared 7 October 97

Foil 34 An Example of PL/SQL Stored Procedure - III

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
BEGIN
OPEN person_cur(name); -- open the cursor
LOOP -- Fetch each row matching
  • the query into variables repeatedly
FETCH person_cur INTO lname,fname,phone,ptype;
EXIT WHEN person_cur%NOTFOUND;
    • -- check end of result buffer
/* print out the query result */
htp.p('The '||ptype||' phone no. of' ||fname||' '||lname||': '||phone);
END LOOP;
CLOSE person_cur;-- close the cursor after it is done
END get_person_by_name;

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Feb 5 1998