Win a copy of Kotlin in Action this week in the Kotlin 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
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!