Access stored procedures via JDBC
Posted on 1998-09-28
I've written PL/SQL stored procedures and want to
execute them from within a Java programm.
In the stored procedures I use a datatype
"type s_array is table of varchar2(200)
index by binary_integer;"
as a parameter.
On the Java side I use an array of strings. How do I map
the (SQL) table of varchar into a (Java) array of strings?
There are methods to map simple datatypes and there are
the methods getObject and setObject. Do I have to use them?
A simple source code example would be nice!