Printable View
can anyone help me for how to pass a multi dimensional array to a stored procedure?
I want to pass 3 diffrent columns value as an array to a stored procedure.
i.e.
1. empno
2. ename
3. sal
These 3 columns i want to pass as an multi dimensional array.
I think most of your questions will be answered by these threads:
http://www.dbasupport.com/forums/sho...threadid=19196
http://www.dbasupport.com/forums/sho...threadid=19824
http://www.dbasupport.com/forums/sho...threadid=19712
The first one gives an INDEX BY TABLE and a VARRAY example.
Good luck.