Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to consume output parameter of type RECORD or TABLE

719717Aug 27 2009 — edited Aug 27 2009
Hi 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;

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 24 2009
Added on Aug 27 2009
2 comments
1,459 views