Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » EclipseLink DBWS - Using records/object arrays as input/output Types
EclipseLink DBWS - Using records/object arrays as input/output Types [message #651811] Tue, 01 February 2011 17:09
No real name is currently offline No real nameFriend
Messages: 1
Registered: February 2011
Junior Member
I'm trying to create a dbws project that wraps an Oracle package, containing stored procedures with complex input and output types. The following is an example:

TYPE rPersonRecord IS RECORD (
first_name varchar2(32),
last_name varchar2(32)
address_list tAddressList
);

TYPE rPersonCursor IS REF CURSOR
RETURN rPersonRecord;

FUNCTION get_person_info (
inPersonSSN CHAR(9)
)
RETURN rPersonCursor;

tAddressList is defined as follows:

CREATE OR REPLACE TYPE tAddressList AS TABLE OF tAddress;

CREATE OR REPLACE TYPE tAddress AS OBJECT
(
street_name VARCHAR2 (64),
street_number NUMBER
...
);

Do I use the sessions.xml and/or the or/ox xml config files to define mappings for these? I couldn't seem to find much googling as it relates specifically to dbws.

Thanks - Brian
Previous Topic:stale data refreshed after a size()?
Next Topic:Could not define uni-directional @OneToMany mapping
Goto Forum:
  


Current Time: Fri Mar 29 15:14:22 GMT 2024

Powered by FUDForum. Page generated in 0.03364 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top