how to return a cursor in a PL/SQL procedure or function ?
From: Sy Jerry <SYJERRY_at_duq3.cc.duq.edu>
Date: 22 Nov 1994 15:32:15 GMT
Message-ID: <3at2tv$nna_at_godot.cc.duq.edu>
Date: 22 Nov 1994 15:32:15 GMT
Message-ID: <3at2tv$nna_at_godot.cc.duq.edu>
I recently posted a question if it is possible to return multiple
rows in a PL/SQL procedure or function and I got two responses
saying that it can be done using cursors, but did not get any sample
code.
I tried doing it but got compilation errors.
I did a test script that will return all cities in a given state.
my script is as follows
create or replace package Test_Pack is
Function Test(state sys.cities.cty_sta_code%type)
Return cursor;
end Test_Pack;
Received on Tue Nov 22 1994 - 16:32:15 CET