*
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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: 2491
    
    8

Welcome to the Ranch, Wei!


OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to call stored proc with index-by-varchar table parameters
 
Similar Threads
trouble passing array to stored procedure in spring HELP
registerOutParameter for table?
passing an array of objects to stored proc(Oracle)
Passing PL/SQL table from Stored Proc to Java
CallableStatement Error