# Displaying a OUT parameter and REF cursor at the sametime.

**URL:** <https://forums.toadworld.com/t/displaying-a-out-parameter-and-ref-cursor-at-the-sametime/30572>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 30, 2014, 8:20am UTC](https://forums.toadworld.com/t/displaying-a-out-parameter-and-ref-cursor-at-the-sametime/30572 "2014-07-30T08:20:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![wandecoal85](https://avatars.discourse-cdn.com/v4/letter/w/b19c9b/32.png) [@wandecoal85](https://forums.toadworld.com/u/wandecoal85)\
**Post date:** [July 30, 2014, 8:20am UTC](https://forums.toadworld.com/t/displaying-a-out-parameter-and-ref-cursor-at-the-sametime/30572/1 "2014-07-30T08:20:46Z")

</div>

is this possible in toad , to have a procedure that has one OUT paramater and another OUT in the form of a sysref\_cursor

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [July 31, 2014, 1:20pm UTC](https://forums.toadworld.com/t/displaying-a-out-parameter-and-ref-cursor-at-the-sametime/30572/2 "2014-07-31T13:20:08Z")

</div>

procedure may have out parameters as many as you want. I do not see problem.

Maybe if you could show some example so we can help you.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [August 4, 2014, 3:46am UTC](https://forums.toadworld.com/t/displaying-a-out-parameter-and-ref-cursor-at-the-sametime/30572/3 "2014-08-04T03:46:27Z")

</div>

create or replace procedure refcursor\_demo (myMsg out VARCHAR2, c out SYS\_REFCURSOR)  
AS

BEGIN  
OPEN c FOR select \* from user\_tables;  
myMsg := ‘Cursor open correctly’;  
exception  
when others then  
myMsg :=‘cursor open failed with ‘|| SQLCODE ||’ code’;  
END;

But do not forget to close sys\_ref cursor explicitely wehn is not needed!

---

<div class="post-metadata">

**Author:** ![wandecoal85](https://avatars.discourse-cdn.com/v4/letter/w/b19c9b/32.png) [@wandecoal85](https://forums.toadworld.com/u/wandecoal85)\
**Post date:** [November 3, 2014, 5:56am UTC](https://forums.toadworld.com/t/displaying-a-out-parameter-and-ref-cursor-at-the-sametime/30572/4 "2014-11-03T05:56:16Z")

</div>

SQL developer can display an out parameter and another Ref cursor out parameter at the same time.

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [November 3, 2014, 6:09am UTC](https://forums.toadworld.com/t/displaying-a-out-parameter-and-ref-cursor-at-the-sametime/30572/5 "2014-11-03T06:09:10Z")

</div>

You need to set the output options.

 ![output.jpeg](https://global.discourse-cdn.com/quest/original/2X/4/408df4dd31c72629a52de0e383e0a3238d940f50.jpeg)
