Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic