How to consume output parameter of type RECORD or TABLE
719717Aug 27 2009 — edited Aug 27 2009Hi all,
What type of OracleDbType in OracleParameter should I use to receive RECORD or TABLE as an output parameter?
Can anyone provide an example on how to call get_user and get_members stored procedures defined in the package definition below?
Thank you.
create or replace PACKAGE TEST_PKG
AUTHID CURRENT_USER
AS
type person_record is record (
name varchar2(100),
area varchar2(50)
);
type person_table is table of person_record;
procedure get_user(
i_name IN varchar2,
o_person_record OUT NOCOPY person_record);
procedure get_members(
i_area IN varchar2,
o_person_table OUT NOCOPY person_table);
END TEST_PKG;