Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

callablestatement calling multiple functions that perform multiple tasks  RSS feed

 
charles mee
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a callable statement that is calling an Oracle function, which in turn is calling 3 functions within a package. two of the functions do a select and one does an insert. What method do i use? I have tried executeQuery and execute. executeQuery seems to run the two functions that do a select, but won't execute the function that inserts.
execute seems to not even get that far (ie: it doesn't seem to execute the selects and returns false).
Any thoughts?
 
charles mee
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
yeah, so figured it out. problem seems to be on oracle side. Pretty cool when it works though.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!