# Beta Released (12.8.0.25)

**URL:** <https://forums.toadworld.com/t/beta-released-12-8-0-25/34076>\
**Category:** Toad for Oracle - Beta\
**Created:** [September 9, 2015, 4:15am UTC](https://forums.toadworld.com/t/beta-released-12-8-0-25/34076 "2015-09-09T04:15:21Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dennis\_Paulus](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dennis_paulus/32/138_2.png) [@Dennis\_Paulus](https://forums.toadworld.com/u/Dennis_Paulus)\
**Post date:** [September 9, 2015, 4:15am UTC](https://forums.toadworld.com/t/beta-released-12-8-0-25/34076/1 "2015-09-09T04:15:21Z")

</div>

Beta Notes  
Editor  
The Ref Cursor Results dock panel has been re-branded PL/SQL Results. It will show all input and output values in one place w/o needing to use DBMS output.

The Set Parameters window allows you to set input value as an expression. If the expression column is checked the Value field is inserted as-is into the anonymous block.

The Output Options tab in Set Parameters has a couple of minor tweaks for cursor output. Fetching into memory and sending to DBMS output are no longer mutually exclusive. The “Fetch cursor data” option is the same as the old “load into grid” option, but in the PL/SQL Results tab you’ll see “(CURSOR)” for cursor outputs. Double clicking the cell will open the cursor data viewer.

Team Coding

- The SCC Provider Engine has been completely rewritten and now supports through version 1.3 of the SCC API specs. As a result, the ability to use extended features, such as sub-folders, within Team Projects through an SCC Plugin Provider is now available provided that the manufacturer’s SCC provider implements those features. A “settings” dialog has been added to the Team Coding Configuration and Administration windows which will display the supported SCC API version of the plugin as well as a list of features implemented by the SCC Plugin Provider.
- In addition, customers using SCC Plugin Providers can once again browse and work with VCS projects and files from within the VCS tab of the Team Coding Manager.
- Also, file and object detail information that was previously available through a custom drop-down off the selected VCS or TC Object have been moved to their own window and can be viewed by selecting “Show Properties” off the right-click context menu. However, quick information about the VCS / TC Object can still be viewed in a hint by simply hovering over the item.

Resolved Issues  
Issue  
ID  
TC with SVN: Team Coding Manager does not show tree structure correctly  
118531

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [September 23, 2015, 6:07am UTC](https://forums.toadworld.com/t/beta-released-12-8-0-25/34076/2 "2015-09-23T06:07:40Z")

</div>

I’ve a couple of stored procedure what we use as Crystal Reports source tables, and every procedure’s first parameter is a ref cursor.

What are the exact steps to get the result of the OUT parameter for this ref cursor in PL/SQL Result tab? I’m using an anonymous block, where I define the values of every input parameter with an explicit assign before the call of procedure. If I’m using F9 to run the anonymous block.

I appreciate your help.

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [September 23, 2015, 6:30am UTC](https://forums.toadworld.com/t/beta-released-12-8-0-25/34076/3 "2015-09-23T06:30:50Z")

</div>

Define a bind for your cursor and set its datatype to "cursor" in the bind vars popup. The results appear in the data grid. Here's an example.

CREATE OR REPLACE PROCEDURE cursor\_out\_param (c\_out OUT SYS\_REFCURSOR)

AS

BEGIN

OPEN c\_out FOR SELECT \* FROM user\_objects;

END;

BEGIN

cursor\_out\_param(:cur);

END;

On 09/23/2015 09:11 AM, drbubo20 wrote:

> **[RE: Beta Released (12.8.0.25)](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/25394/56282#56282)**

> Reply by drbubo20  
> I've a couple of stored procedure what we use as Crystal Reports source tables, and every procedure's first parameter is a ref cursor.

> What are the exact steps to get the result of the OUT parameter for this ref cursor in PL/SQL Result tab? I'm using an anonymous block, where I define the values of every input parameter with an explicit assign before the call of procedure. If I'm using F9 to run the anonymous block.

> I appreciate your help.

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/25394?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Beta Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/25394/56282?AbuseContentId=290fff92-ba21-4370-a74a-9a222837d02c&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [September 23, 2015, 7:06am UTC](https://forums.toadworld.com/t/beta-released-12-8-0-25/34076/4 "2015-09-23T07:06:07Z")

</div>

Ok, that was the same logic I used but there is no output on PL/SQL Result tab. Should I use F9 for running the statement? Does it work with strongly typed defined ref cursors?

My proc looks like this:

CREATE OR REPLACE PROCEDURE rep\_\_kivonatok\_dc\_partner (  
out\_refcur IN OUT crystal\_dba.rc\_\_kivonatok\_dc\_partner,  
p\_sttkod IN VARCHAR2,  
…)

in CRYSTAL\_DBA the type definitons are the following:

TYPE rc\_\_dc\_partner IS REF CURSOR RETURN trec\_\_dc\_partner;

TYPE trec\_\_dc\_partner IS RECORD (  
…);

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [September 23, 2015, 7:09am UTC](https://forums.toadworld.com/t/beta-released-12-8-0-25/34076/5 "2015-09-23T07:09:21Z")

</div>

Oh, also...

> What are the exact steps to get the result of the OUT parameter for this ref cursor in PL/SQL Result tab?

You can't if using F9. The PL/SQL Results tab is populated after executing PL/SQL using the execute PL/SQL command (either with, or without debugger). F11 is the default shortcut for execute w/ debugger. Execution using F9 is somewhat different and requires the manual use of binds whereas F11 creates an execution harness for your PL/SQL call and sets up binds automatically for various uses.

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [September 23, 2015, 7:33am UTC](https://forums.toadworld.com/t/beta-released-12-8-0-25/34076/6 "2015-09-23T07:33:31Z")

</div>

I think I got it. If I use an anonymous block manually what you suggested in your first example and I use F9 to run it, the output will be generated on Data Grid tab. I was looking for it on PL/SQL Result tab.

If i use F11 on my procedure tab, I get the pop-up, but I think there are errors with the generated script. I send the script and the stored procedure to you, offline.

T.
