Win a copy of Java Concurrency Live Lessons this week in the Threads forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Passing array of values from java to PL/SQL  RSS feed

 
Kannan Palani
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All
Will it be efficient to pass array of values from Java to PL/SQL?
Thanks
Kannan
 
rajesh bala
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would say its driver dependent.

~Rajesh.B
 
Viswa Ambal
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can pass array(1D, 2D, ...). This is driver dependent. If you use Oracle as DB, you have to wrap your ordinary connection with OracleConnection.You should use ARRAY and ArrayDescriptor to pass the array.
Hope will give some idea.
 
Kannan Palani
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a lot
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!