Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bug in plsql version of decompose

User_IVLGFApr 25 2022

The pl/sql version of decompose adds seemingly random noise to the end of certain canonically decomposable strings, provided they have sufficient length. This also occurs on oracle live sql, but also in oracle 12c, so probably also in all versions in between. Strangely, the sql version of decompose works fine.

Reproduction script:

with
function plsql_decompose(string in varchar2)
return varchar2
is
begin
return decompose(string);
end;
asian as (select rpad(lpad('분',20+level, '가'), 20+2*level, '가') || '분' string from dual connect by (level <= 20))
select asian.string, decompose(asian.string), plsql_decompose(asian.string) from asian;

Comments
Post Details
Added on Apr 25 2022
0 comments
115 views