How to pass an array as parameter from Hibernate to PL/SQL? -


I need to cross the integer of the PL / SQL function from hibernate. I Current solution is a comma separated string with a secret array And surrounds it with brackets to use it as a parameter. This solution is outlined.

However, this approach does not look like a good solution when an array of elements of 200 need to be passed.

Is there any way to create this array using hibernate?

EDIT: I am using PostgreSQL.

This will not be advised to pass the 200k element array in a database function. I think that there will be a better approach to putting these values ​​into a separate table, then call the function and refer it to the table.


Comments

Post a Comment