Can we pass null values to array parameter of stored proc
Posted: Fri 19 Mar 2010 21:40
Hi,
I have a stored procedure that accepts a string array as an input parameter. Will I be able to pass a null value or an empty array to the parameter?
I found that passing empty array or null value do not work with ODP. I wanted to know if Devart can handle this or is it a function of the Oracle database itself that it does not accept such values for an array type parameter?
Thanks.
I have a stored procedure that accepts a string array as an input parameter. Will I be able to pass a null value or an empty array to the parameter?
I found that passing empty array or null value do not work with ODP. I wanted to know if Devart can handle this or is it a function of the Oracle database itself that it does not accept such values for an array type parameter?
Thanks.