Re: Passing a null value to a stored procedure from Java (DBMS_SQL.Varchar2_Table)

On Mar 9, 10:08 am, rafa..._at_gmail.com wrote:
> Hi,
>
> Can anyone tell me how to pass a null value as IN parameter to a PL/
> SQL stored procedure?
>
> E.g:
>
> PROCEDURE sendMessage(p_tuIds IN DBMS_SQL.Varchar2_Table) (...)
>
> It works well with filled array using OracleCallableStatement:
>
> cs.setPlsqlIndexTable (index, values, maxLen, currentLen, elemSqlType,
> elemMaxLen);
>
> Question is - what method should I use to pass an empty (or null)
> table?
>
> Thanks in advance for your help!

Probably you should pass an empty table
That is a table variable initialized with <table type> ();

Hth

--
Sybrand Bakker
Senior Oracle DBA