CLOB as array?

[jschmied]

I have a question similar to the topic "Inserting BLOBs fast?"

Can I return somehow a array of CLOBS from a PL/SQL function?

Well, it is the question from the thread above, but there is no answer jet ;-)

Thanks

Juergen

 

[Marco Kalter]

If you define an object type as varray of clob, you can pass this object to a stored procedure:

create type clob_array as varray(10) of clob;

The ClobArray can be accessed through the TOracleObject class.

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