Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Stored Procedure with custom data type of oracle(How to call stored procedure with custom data type of oracle)
Stored Procedure with custom data type of oracle [message #1785848] Fri, 20 April 2018 15:19
nivrutti shinde is currently offline nivrutti shindeFriend
Messages: 2
Registered: April 2018
Junior Member
PROCEDURE create_pr(
p_create_ IN table_product,
p_product IN varchar2,
result_out OUT VARCHAR2,
messages_out OUT message_array, --Type of varray of varchar(400)
errors_out OUT _error_list); --Type of object

I am unable to map oracle custom data types to pojo. I searched lot but not able to get simple complete example of how to call stored procedure which has custom data type as output parameter, my one output is type of varray of varchar and another output parameter is of type object which contains 4 different column

In short the Problem Statement Need to call stored procedure which contain output parameter as user define type in oracle. We need to map this user define type to java objects while calling oracle.

I saw @Array and @Struct, @Resultsetmapping but not able to get breakthrough. If you could share some sample code. Will much appreciated

it is very frustrating not able to find any single complete example how to do it

Previous Topic:How to create footnote in BIRT?
Next Topic:create Data Source with .csv
Goto Forum:

Current Time: Mon Nov 19 11:21:04 GMT 2018

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

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

Back to the top