You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account. Question and Answer. You Asked Hello! Robert, December 04, - am UTC. Tom, Would you use this if you were passing out a reference cursor and wanted to update the rows that you have passed.
For example we have a ref cursor that selects based on processed value of 1. We need to update that value to 2 after we have passed the rows back. December 04, - am UTC. The row's will be locked by the client process that calls this procedure, they will fetch the row, process it and update it by rowid fast.
A reader, October 15, - am UTC. Hi Tom, I need to do the same thing as reviewer Robert - return the result set to the client and "flag" those selected records; and it all either has to succeed or fail.
I tried the example above but I simply can't manage to return the result set. Can you please provide me an example. Many thanks! October 15, - am UTC. A reader, October 15, - pm UTC. What we are trying to do is to retrieve the data from a table to a client side and for those data selected to update the status so these are not processed when the retrieval process is started again.
We tried to do this using ref cursor but we don't know how to actually retrieve data. If you take example you provided above that is kind a logic we need. If that were a stored procedure called from a client waiting for a result set - how can we do it. October 15, - pm UTC. Thanks Tom. Can you please see previous review with code - client is expecting a result set - that's what we are trying to get there. Gabe, October 15, - pm UTC. You ["A reader"] seem in a hurry I just used it to demonstrate what we want to achieve.
We have no problem with the update. We have problem with not getting result set - that's what we need. Not sure what result set you want to see: 1. You just need to open the cursor again Anyway, better stop before Tom tells me "get your won site".
And you better check back to see what he has to say I'm just trespassing : Cheers. Hi Tom. Asked 3 years, 3 months ago. Active 3 years, 3 months ago. Viewed 5k times. NET, b. Improve this question. It's still going to be faster to update the table in a single update statement than to do the bulk update.
Show 4 more comments. Active Oldest Votes. Improve this answer. Add a comment. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.
0コメント