# Beta Released (13.0.0.43)

**URL:** <https://forums.toadworld.com/t/beta-released-13-0-0-43/40548>\
**Category:** Toad for Oracle - Beta\
**Created:** [February 1, 2018, 11:37am UTC](https://forums.toadworld.com/t/beta-released-13-0-0-43/40548 "2018-02-01T11:37:54Z")\
**Posts on this page:** 2\
**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:** [February 1, 2018, 11:37am UTC](https://forums.toadworld.com/t/beta-released-13-0-0-43/40548/1 "2018-02-01T11:37:54Z")

</div>

**Beta Notes**

Compare Schemas

Schema Compare is now threaded, so should not block other activities in Toad.

Formatting/Parsing (QP5)

## Formatter

Fix (QP 2788) :

- Distance between parameters and data types fixed to become exactly one indent (from one indent + one space). This change is due to a required major refactoring of the parameter declaration formatter code.
- Stacked parameter declaration lists now have the IN, OUT, INOUT and NOCOPY keywords of their parameter declarations justified:

```auto

CREATE PROCEDURE astron.extern (
                         IN a DATE,
                        OUT CHAR,
                        INOUT c TIMESTAMP)

FUNCTION func1 (par1 INT,
par2 IN INT := 3,
par3 INT := 3,
par4 IN OUT NOCOPY INT)

```

## Code Analysis

Fix (QP 2800) : Rule 5914 (“Use untransformed column values in the WHERE clause.”)

- Speedup (around 70 times) fixing possible multi-second delays.

- Parameter specifications were not taken into account.  
Fix (QP 2786) : Rule 5920 (“Apply the invoker rights method to all stored code that executes dynamic SQL”)

- Speedup (around 70 times) fixing possible multi-second delays.  
�

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [February 3, 2018, 2:39am UTC](https://forums.toadworld.com/t/beta-released-13-0-0-43/40548/2 "2018-02-03T02:39:03Z")

</div>

The formatter examples should read as follows:

```auto
   CREATE PROCEDURE astron.extern (
IN a DATE,
OUT CHAR,
INOUT c TIMESTAMP)
FUNCTION func1 (par1 INT,
par2 IN INT := 3,
par3 INT := 3,
par4 IN OUT NOCOPY INT)

```
