Urgent: empty nested table parameters

[lev_ko]

Hello,

I have a PL/SQL function that accepts a nested table of integers and returns another nested table of integers.

I need to know how I can use DOA 3.4.3 to pass null (or empty) nested tables to and from that function.

Thanks,
Lev

 

[Marco Kalter]

A nested table is encapsulated by the TOracleObject class, which can be passed to a function through a otObject variable. The collection object can be null or empty.

------------------
Marco Kalter
Allround Automations

 

[lev_ko]

Thanks.

Actually I managed to find another solution that works, which is using an empty variant array and calling DimPLSQLValue with the maximum size greater than zero.

However, I have another question. I have a stored function that returns an OUT parameter that is a nested table. Can I call the function without having to define the maximum size of the return value using DimPLSQLTable?

If I call DimPLSQLValue and set the maximum size for the variable, the result may be truncated if its size exceeds the maximum.