PL/SQL Arrays

From: <fzoufaly_at_lapa.cic.itcr.ac.cr>
Date: 22 Jul 1994 12:33:49 -0500
Message-ID: <9407221727.AA07210_at_lapa.cic.itcr.ac.cr>

Hello.

Actually PL/SQL only support scalar datatypes in an array. However, you could define a package where you can define several arrayas (one per each component of the record) and then write some access procedures.
In this way, the application will see an array through the access procedures. You will have the further benefit of having global arrays, since variables in a package persist during the whole connect session.

Hope this helps.
Greetings, Federico.

---

Federico Zoufaly
Centro de Investigaciones en Computacion Instituto Tecnologico de Costa Rica
e-mail: fzoufaly_at_cic.itcr.ac.cr Received on Fri Jul 22 1994 - 19:33:49 CEST