VARRAY in PLSQL [message #227394] |
Wed, 28 March 2007 02:36 |
Sabby
Messages: 1 Registered: March 2007
|
Junior Member |
|
|
ALL
I need to create a 2 dimensional Varray in Pl/sql stored procedure.
I need to have 2 fields in it, one would be the older column values and other the newer column values for the same column for a given table. This column defines the path of the physical location of files.
This 2D array would be passed onto a JAVA file which needs to pass another set of values to a UNIX file to physically manipulate reports on server.
Can you please let me know how can i declare a 2 D varray and use it to pass the values to a JAVA file. This should act in the same way as a VECTOR does in C/C++.
The current proc is attached herewith.
Thanks
Sabby
|
|
|
|