Help on Stored procedures(Urgent)

    I want to know whether we can declare an array of varchar(64), as an out parameter in a stored procedure. if yes, how should i do it. what is the syntax for declaring such a stored procedure parameter and how will i load or get values from that array.

The requirement is to return a list of strings, dates, numbers(out parameters) from a stored procedure, which can be retrieved as Array objects through JDBC from java.

    i am new to PL/SQL and stored procedures. please mail me if u have the answer.

thanks in advance
ramesh Received on Sat Jun 10 2000 - 00:00:00 CDT