Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
weiran zhou
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the Ranch, Wei!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic