J
jacksu
I know JDBC array has been discussed a lot in the web, but seems it
still have a lot of problems.
I have a stored procedure which has two out array parameter:
procedure MYProc (
mykey IN varchar2,
myValue OUT mytable);
create or replace type mytable is table of varchar2(200);
In my java code,
stmt.registerOutParameter(2, java.sql.Types.ARRAY, "MYTABLE");
but when I tried to access MyProc, I got error:
ORA-06531: Reference to uninitialized collection
I also tried to call setArray to set a preallocated array, still got
the same error.
I also tried the typemap to put MYTABLE in the type map, seems no
use..
Any advice is highly welcome.
still have a lot of problems.
I have a stored procedure which has two out array parameter:
procedure MYProc (
mykey IN varchar2,
myValue OUT mytable);
create or replace type mytable is table of varchar2(200);
In my java code,
stmt.registerOutParameter(2, java.sql.Types.ARRAY, "MYTABLE");
but when I tried to access MyProc, I got error:
ORA-06531: Reference to uninitialized collection
I also tried to call setArray to set a preallocated array, still got
the same error.
I also tried the typemap to put MYTABLE in the type map, seems no
use..
Any advice is highly welcome.