how to call stored proc with index-by-varchar table parameters

[weiran zhou]

Hi,

I have a stored proc with input parameter of type:

TYPE token_value_tt IS TABLE OF VARCHAR2(480) INDEX BY VARCHAR2(50);

I have a java map object which stores the key-value pairs which I think the key corresponding to INDEX.

How to pass this java map object into the stored proc using JDBC?

Thanks,
Wei

[Jan Cumps]

Welcome to the Ranch, Wei!