Stored Proc ( Urgent)

[Guest_imported]

how can I pass a set of rows from my java program to a stored procedure. I am using oracle 8i.I am not allowed to use a cursor.
So over here I require to know 2 things:-
1.
what parameter can my Stored proc have to be passed a group of records ?
2.
how do I map this parameter to my java program which is calling this stored proc .
If possible please give exact syntax & scrips with examples.
Thank you.

 

[rcurva]

I am quite confuse about your statement "I am not allowed to use a cursor", why?

Try to create a procedure that accepts REF CURSORS or table of records.