Thanks for you suggestions, Avi. I visited both these sites and have even downloaded few samples. But the samples do not demonstrate the way to pass a hashtable to PL/SQL stored procedure. The problem is Hashtable is not a compatible type in Oracle. They have to be converted into objects and sent as an object array. I have 13 items to send in the hashtable and converting every item into object and packing them into an array clutters the code. I wanted to see if there was a better mechanism to send a (key,value) pair as a parameter to a PL/SQL procedure from my Java program. Thanks for your efforts and time. cheers, Amit.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads