Home » SQL & PL/SQL » SQL & PL/SQL » VARRAY in PLSQL
VARRAY in PLSQL [message #227394] Wed, 28 March 2007 02:36 Go to next message
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
Re: VARRAY in PLSQL [message #227592 is a reply to message #227394] Wed, 28 March 2007 13:57 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
consider JAVA opening a ref cursor.
http://asktom.oracle.com/tkyte/ResultSets/

http://sheikyerbouti.developpez.com/collections/collections.htm
Previous Topic: using variable in a query!!!
Next Topic: Help w/ DECODE
Goto Forum:
  


Current Time: Tue Dec 03 16:02:22 CST 2024