Hi

We have upgraded our biovia direct version to 2024. Our application executes a few queries that now fails. Here is the smallest query that produces an error.

This query works perfectly fine:
SELECT cdbregno, molfile(ctab) FROM moltable WHERE Structure_Id IN (1182252);

But this query fails:
SELECT cdbregno, molfile(ctab) FROM moltable WHERE Structure_Id IN ((SELECT 1182252 FROM dual));

with this error:

ORA-20100: MDL-0199: Unable to get length of LOB: ORA-21302: object snapshot error: conversion will result in loss of information
MDL-0199: Unable to get length of LOB: ORA-21302: object snapshot error: conversion will result in loss of information
MDL-0021: Unable to copy LOB to string
MDL-0636: Unable to unpack binary molecule ctab to internal handle
MDL-1114: Error converting packed molecule to molfile, Chime or Gzip64 CLOB
ORA-06512: at "C\\\$DIRECT2024.MDLAUXOP", line 396
ORA-06512: at "C\\\$DIRECT2024.MDLAUXOP", line 365

For reference, this works perfectly fine, when not selecting molfile(ctab):

SELECT cdbregno FROM moltable WHERE Structure_Id IN ((SELECT 1182252 FROM dual));
 

Can you help me understand why this error occurs when executing nested select?
Thanks