Python seems to be a very convenient way to transfer data to and fro Oracle. It has capabilities to set up a connection and it seems quite capable to transfer a matrix into a table and vice versa. Next code shows this. It first retrieves the content of a table. In a second step some data from a matrix are stored into a table.
import cx_Oracle con = cx_Oracle.connect('scott/bunvogni@van-maanen.com/orcl') cur = con.cursor() cur.execute('select * from departments order by department_id') res = cur.fetchall() print res rows = [ (1, "First" ), (2, "Second" ), (3, "Third" ), (4, "Fourth" ), (5, "Fifth" ), (6, "Sixth" ), (7, "Seventh" ) ] cur = con.cursor() cur.setinputsizes(int, 20) cur.executemany("insert into mytable(id, data) values (:1, :2)", rows) con.commit() con.close()