Topic: Stored procedures, difficult data structures on an input
Colleagues good afternoon!
Educate me please on stored procedures and functions.
Whether there is a possibility to transfer in storable PL\SQL procedure a difficult data structure for example List, Map or .?
For example is to save a question and its possible variants of answers, they will be saved in two tables.
This structure on Java to the side is easily described by standard collections or Json somehow.
It seemed to me what here pertinently to create stored procedure to transfer to it the data and let she already writes as it is necessary. two calls JDBC of the driver from Java I will have one. However I faced that how to transfer a difficult data structure.
Generally at me on the project eternal dispute, stored procedures are necessary to us or not.
One of fears it that stored procedures to us development and application update.
In this plan how much these fears are justified? After all I so understand, what update of stored procedure it simply start SQL of a script with CREATE OR REPLACE PROCEDURE?