[GENERAL] Is there a simple function for copiing cursor data into array?

Hi list, I am searching for function which creates or appends to array content of cursor. I found that it is possible to get select result as array so it is probably logical to have something similar for cursors. I mean, there is copy-paste from documentation for 8.3 version: - SELECT ARRAY(SEL

[GENERAL] JDBC: How to pass array in prepared statement for stored procedure execution?

Hi list, This question is general for any database JDBC but I think it's ok if I post it here. Lets say I have s stored procedure which gets an array of objects like one of it IN parameters. How can I pass an array of my objects into JDBC PreparedStatement object? The only recomendation I saw was t