# Can't compile PL/SQL block 13.0.0.64

**URL:** <https://forums.toadworld.com/t/cant-compile-pl-sql-block-13-0-0-64/40743>\
**Category:** Toad for Oracle - Beta\
**Created:** [March 21, 2018, 7:31am UTC](https://forums.toadworld.com/t/cant-compile-pl-sql-block-13-0-0-64/40743 "2018-03-21T07:31:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rtx](https://avatars.discourse-cdn.com/v4/letter/r/49beb7/32.png) [@rtx](https://forums.toadworld.com/u/rtx)\
**Post date:** [March 21, 2018, 7:31am UTC](https://forums.toadworld.com/t/cant-compile-pl-sql-block-13-0-0-64/40743/1 "2018-03-21T07:31:31Z")

</div>

DECLARE  
s VARCHAR2 (32767);  
BEGIN  
s := s || q’[order by regexp\_substr(cc.contnum, ‘[[:alpha:]]+’)  
, to\_number(regexp\_substr(cc.contnum, ‘(\d)+’, 1, 1))  
, to\_number(regexp\_substr(cc.contnum, ‘(\d)+’, 1, 2))]’;  
END;  
/

---

<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:** [March 21, 2018, 8:41am UTC](https://forums.toadworld.com/t/cant-compile-pl-sql-block-13-0-0-64/40743/2 "2018-03-21T08:41:18Z")

</div>

This is a bug in the data access component version used in Toad 13. I’ve opened a support ticket with them.

In the meantime as a workaround you can choose chars other than square brackets for your Q-Quote. Example, q’\<…\>’ works with your sample.

Michael

---

<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:** [May 25, 2018, 10:03am UTC](https://forums.toadworld.com/t/cant-compile-pl-sql-block-13-0-0-64/40743/3 "2018-05-25T10:03:39Z")

</div>

This is fixed in the next beta.