Passing empty Associative Array
39465Jan 1 2004 — edited May 14 2012hi,
ive got a stored procedure with an in parameter of type :
TYPE t_my_list IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
it all works good when passing an array that has values, but i get less encouraging results when attempting to pass an "empty" list.
ive tried setting parameter.value = dbNull.value as per the documentation but this returns "OracleParameter.Value is invalid"
ive tried setting parameter.value to a zero sized array of strings but this gives me a 3113 (session disconnected), followed by some ORA-12500 and i have to restart the database to be able to connect from anywhere (including bequeath!).
any ideas?
thanks
greg