At the moment (12.0.38) the BLOB and CLOB types are not available in the SQL query tool. We would like to create requests that include the comments on a Product, but currently this option isn't available as you get Error: Parameter type incompatible cmptyp" when using CLOB in SQL query tool query. The same query works in SQL directly. This was planned for enhancement in Jan 2024, with no ETA, but this error still occurs.
Guest
