Oracle Tip: Execute Stored Procs with Ref.Cursors

The other day at work while I was troubleshooting a problem I needed to execute a stored proc that used a IN/OUT ref cursor. I had never did this before. So after spending some time googling, I figured out it is not as complicated after all. So here it goes for all those people who are looking to do the same:

variable myVar refcursor;

exec(ute) my_store_proc_name(‘param1′,’param2′,’param3’,……,:myVar);

print myVar;

Hope this helps out…..

21 comments for “Oracle Tip: Execute Stored Procs with Ref.Cursors

  1. July 9, 2011 at 7:09 pm

    I am glad that I observed this website , just the right information that I was looking for! .

  2. July 10, 2011 at 1:25 pm

    Hey, I love this site just thought I would let you know 😀

  3. July 12, 2011 at 7:14 pm

    I like the valuable info you provide in your articles. I’ll bookmark your weblog and take a look at once more right here frequently. I’m reasonably certain I’ll learn plenty of new stuff right right here! Best of luck for the following!

  4. September 16, 2011 at 7:19 am

    Nice posts. I like reading your posts. You’ve a talent!

  5. September 28, 2011 at 5:49 pm

    1st Off, let me commend your clearness on this issue. I am not an expert on this matter, but soon after looking at your guide, my understanding has developed considerably. Please make it possible for me to grab your rss feed to stay in contact with any forthcoming updates. Optimistic task and will give it on to acquaintances and my visitors.

  6. September 30, 2011 at 3:35 am

    Your place is valueble for me. Will bookmarked it for sure ! Thanks SEO

  7. October 7, 2011 at 5:22 pm

    Awesome website you have here, I’ll be sure to come back

  8. October 7, 2011 at 6:58 pm

    Nice read, I just passed this onto a friend who was doing some research on that. And he actually bought me lunch as I found it for him smile Therefore let me rephrase that: Thanks for lunch! “Creativity comes from zeal to do something, generally it is to make some money.” by B. J. Gupta.

  9. October 8, 2011 at 3:55 am

    Loving the info on this internet site , you have done great job on the blog posts.

  10. October 10, 2011 at 9:34 pm

    I love the efforts you have put in this, regards for all the great blog posts.

  11. October 11, 2011 at 11:07 pm

    I was looking at some of your articles on this internet site and I think this site is real informative ! Retain posting .

  12. November 30, 2011 at 2:16 am

    Hey there would you mind sharing which blog platform you’re using? I’m planning to start my own blog soon but I’m having a difficult time making a decision between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I’m looking for something unique. P.S My apologies for getting off-topic but I had to ask!

  13. December 12, 2011 at 1:52 pm

    Nice post. Keep it up.

  14. January 15, 2012 at 11:27 pm

    Greeting there administrator, I mainly desired to actually make a short mention to point out that I liked your specific blog post. Thanks!

  15. June 11, 2012 at 11:59 pm

    Wow, what a neat blog. I loved your narrating and will bookmark the article.

  16. June 12, 2012 at 7:47 pm

    That is a nice post. Thanks for sharing. Smilee

  17. June 9, 2014 at 5:54 am

    Appreciate the recommendation. Let me try it out.

  18. June 10, 2014 at 8:00 pm

    Hurrah, that’s what I was exploring for, what a information! existing here at this blog,
    thanks admin of this web page.

  19. August 16, 2014 at 4:56 am

    Hello to all, it’s really a pleasant for me to pay a quick
    visit this web site, it includes valuable Information.

  20. August 23, 2014 at 11:42 pm

    Fine way of explaining, and pleasant post to obtain information concerning my presentation subject matter, which i
    am going to deliver in university.

  21. September 7, 2014 at 7:09 pm

    Wow, marvelous blog format! How lengthy have you ever been running a blog
    for? you made running a blog glance easy. The total look of your web site is excellent, as well as the content!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.