This week's book giveaway is in the Features new in Java 9 forum.
We're giving away four copies of Java 9 Revealed and have Kishori Sharan on-line!
See this thread for details.
Win a copy of Java 9 Revealed this week in the Features new in Java 9 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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!