PL/SQL Tables (correction)

[lev_ko]

I made a mistake in my previous post. Below is the correct question:

I have a stored function that returns an OUT parameter that is a PL/SQL 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]

No, the PL/SQL Table must be allocated on the client before making the call. This is an unfortunate PL/SQL Table limitation.

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