What is the difference between sys refcursor and ref cursor

A ref cursor is considered loosely bound. This means that it is not tied to any specific record set. Great for dynamic sql. On the other hand a cursor requires the sql stmt defined when you declare the cursor. Tightly bound. One can declare his or her own data type with the Ref Cursor where as in the regular cursor one has to know what the output type is going to be hence know the data type.

Hi anshoooman, Thanks for your valuable suggetion,now i can imple ment ref cursor in my procedure. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Could you please tell me how can I effectively answer this question in short.

Your input will be greatly appreciated. Thanks and regards, Praveen. A "normal" plsql cursor is static in defintion. Ref cursors may be dynamically opened or opened based on logic. The ref cursor can be anything.

Another difference is a ref cursor can be returned to a client. 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. Questions Difference between cursor and a ref cursor. Question and Answer. You Asked Hi Tom, Feels good that i got a chance to ask you a question. Good Explain Tom last week I saw a review on this site in which writer name with unknown language to me.

Here I code the name and title of review in my mother language "URDU-Pakistan" do you see it and most important if yes, that How I configure oracle forms and reports for this. December 07, - am UTC. Thanks tom for that great answer with an example. This will be really helpful. You are simply the best.. I wanted to know the same difference and your explanation is what I needed.

Thanks a lot for being there and help so many people. Excellent explanation. Thanks Much. Absolutely understandable I have done it in Arabic.

It really works! A reader, December 29, - pm UTC. December 29, - pm UTC. I learned at least two things, a better grasp of when to use reference cursors, and how to push unrelated questions onto the stack. It is really great to see these differences, but why these were not explained in Oracle Books so simple..

Devesh joshi, March 24, - am UTC. Thanks for helping me out. Clear and comprehensive. No wonder I love your book - Expert One-on-One. I ask about how to change my forms and reports to read in arabic plz send 2 me thx. November 30, - am UTC. This answer gave me the clear difference between cursors and ref cursors I was looking for. Thank you very much Tom.

Krit, April 27, - am UTC. I have no words to describe how simply the concept was explained. I was very confused till now. Thanks Tom,Absoloutely wonderful!! Nice difference Gaurav C. Pandey, May 14, - am UTC. Now i am able to distingiush between Ref.

Absolutely Wonderful!! Really happy to get such concepts cleared. Hi Tom, Most useful, but I need one clarificaiton though. That is, you cannot define a REF cursor outside of a procedure or function in a package description or package body. It can only be handled during the definition of the REF cursor, or returned to the client application. In order to share a static cursor, it must be defined as a global cursor in the package description or in the package body.

This is because of the specific case of people to the discretion bar. This article is an English version of an article which is originally in the Chinese language on aliyun.

This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact alibabacloud. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately. The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud.

If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.