Unanswered: Passing an multi array to sql from java over jdbc
I am fairly new to PL and I am trying to solve this problem.
I need to pass a two dimensional array(A variable Name and Variable value) to a stored procedure in PL/SQL. I dont want to pass this data as a big string..I was hoping to passing it as an array because it would be easier to handle the data.
Basically I would be calling this procedure from a java program over JDBC.
My question is how do I create this...
Since I would be filling this from Java, it would be a parameter within the procedure something like
CREATE OR REPLACE PROCEDURE Test_Response ( pisa_response Varchar )
Of course Varchar is not supported by PL but just showed this to give more understanding of the problem