Click to See Complete Forum and Search --> : Passing an array into a stored procedure


capuccino
August 2nd, 2001, 06:51 PM
I need to pass an array of records(1 record= array of fields) into an oracle stored procedure which would update the records passed into one or more tables. Since there's no straight-forward method in CallableStatement or PreparedStatement which accepts an array, i'm kind of stuck. I know there's java.sql.Array (interface), but that is for mapping user defined data types in ORACLE to javadata objects. Anybody has any thought on this? Pl post ASAP.
Thanks,
capuccino...