spidereddy Posted November 27, 2013 Report Posted November 27, 2013 I have a stored proc like... var1 ; var2; begin for loop Source Table merges with Target table on (Source_table.<key>=target_table<key>) and (condition_x) when matched then update target_table.<column1>=1, target_table.<column2>=1, target_table.<column3>=1, target_table.<column4>=1, target_table.<column5>=1 end loop; end; this works fine.. now I want to get the number of rows which are updated and the execution time of the stored proc and store those values in another table.. how do i do that?? any ideas??
sitaraZahir Posted November 27, 2013 Report Posted November 27, 2013 which version r u using? 2005 or 2008?
spidereddy Posted November 27, 2013 Author Report Posted November 27, 2013 If its oracle use SQL%rowcount yep.. rowcount works,if i declare a var x and then sql%rowcount after commiting the updates.. but how do i stored it in another table.. n how abt execution time?
ravula Posted November 27, 2013 Report Posted November 27, 2013 which version r u using? 2005 or 2008? how does it matter? its a stored proc for heavens sake
spidereddy Posted November 27, 2013 Author Report Posted November 27, 2013 If its oracle use SQL%rowcount it is oracle btw..
SUbba LIngam Posted November 27, 2013 Report Posted November 27, 2013 how does it matter? its a stored proc for heavens sake
sitaraZahir Posted November 27, 2013 Report Posted November 27, 2013 how does it matter? its a stored proc for heavens sake 2008 lo konni advanced features vunnayi... we can just set some attributes and changes anni separate table lo login ayipothayi... read of such feature smwhr but haven't implemented though ! so asked him the version ! and konni system related queries differ avuthayi between versions ...
sitaraZahir Posted November 27, 2013 Report Posted November 27, 2013 it is oracle btw.. oops... ! oracle aithe donn have much idea :(
ravula Posted November 27, 2013 Report Posted November 27, 2013 2008 lo konni advanced features vunnayi... we can just set some attributes and changes anni separate table lo login ayipothayi... read of such feature smwhr but haven't implemented though ! so asked him the version ! and konni system related queries differ avuthayi between versions ... sorry my bad.....no idea about what you are talking about athanu stored proc gurinchi adigadu kada.....and he wants to do the count and store it in another table konchem elaborate about the concept you just mentioned pls
spidereddy Posted November 27, 2013 Author Report Posted November 27, 2013 oops... ! oracle aithe donn have much idea :( no probs scherbatsky..thanks for your time..
sitaraZahir Posted November 27, 2013 Report Posted November 27, 2013 no probs scherbatsky..thanks for your time.. :)
Recommended Posts