Skip to Main Content
Forums

SQL & PL/SQL

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!

WM_CONCAT and DECODE in 11.2.0.2.0

User8675519-OracleDec 14 2010 — edited Dec 14 2010
Has there been a change to the return type of the WM_CONCAT function in the 11.2.0.2 release? The following SQL ran fine in older versions like 11.2.0.1 however in 11.2.0.2 it throws a error looking like WM_CONCAT is now returning a CLOB Type..

select DECODE(WM_CONCAT(table_name),null, 'Test1', 'Test2') from user_tab_privs

Error - ORA-00932: inconsistent datatypes: expected - got CLOB
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2011
Added on Dec 14 2010
4 comments
3,892 views