aspose file tools
The moose likes JDBC and Relational Databases and the fly likes how to call stored proc with index-by-varchar table parameters Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how to call stored proc with index-by-varchar table parameters" Watch "how to call stored proc with index-by-varchar table parameters" New topic
Author

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

weiran zhou
Greenhorn

Joined: Jan 21, 2011
Posts: 1
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
Bartender

Joined: Dec 20, 2006
Posts: 2526
    
  10

Welcome to the Ranch, Wei!


OCUP UML fundamental and ITIL foundation
youtube channel
 
wood burning stoves
 
subject: how to call stored proc with index-by-varchar table parameters