Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

callablestatement calling multiple functions that perform multiple tasks

 
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.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!