| How to construct PL/SQL array at runtime ? [message #45458] |
Wed, 17 March 2004 01:50  |
Shibaji Ghosh
Messages: 39
Registered: April 2002
|
Member |
|
|
Hi,
My application is a two-tier application. Front End passes some parameter to the Stored Procedure (SP). The SP will fetch data based on the input parameter and return the output to FE.
1.> Is is possible to pass a recordset from SP in a two-dimensional array format.
2.> The horizontal as well as the vertical structure of the array is not known until runtime. I presume array implementation in PL/SQL can be done via PLSQL table type. How do I construct the variable of such a type at runtime.
Can anyone help me out !!!
Thanks in advance.
Shibaji
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
