PL/SQL out paramters nested

[lev_ko]

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.

 

[Marco Kalter]

Yes. DimPLSQLTable is not relevant though, because a nestd table is not a PL/SQL Table, but a collection object.

For collection objects you need to use a TOracleObject. You can create an empty TOracleObject instance of the right type, and call TOracleQuery.SetComplexVariable with this instance to associate it with an object variable in the query. The query needs to be something like this:

begin
  my_procedure(..., :v_nested_table, ...);
end;

The :v_nested_table needs to be an Object variable.

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