To get this stuff you
need to create a Ref Cursor to return recordset. create or
replace PACKAGE Types AS TYPE cursor_type IS REF CURSOR; END Types; Now create a stored procedure to return multiple rows . create or
replace PROCEDURE
getAllCity(p_recordset OUT types.cursor_type) AS BEGIN OPEN
p_recordset...
Posted to
Oracle
(Forum)
by
yeotumitsu@sify.com
on
04-15-2008, 12:00 AM
Filed under: Oracle, Parameters, ref cursor, stored procedure, type, bind, direction, grid view