| Stored Procedure with custom data type of oracle [message #1785848] |
Fri, 20 April 2018 11:19 |
Eclipse User |
|
|
|
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
Thanks
Nivrutti
|
|
|
Powered by
FUDForum. Page generated in 0.03437 seconds
Home