SQL query was used to pulling BLOB-LOB data from BioVia symyxdb.vaulttext table.

Property Names

=====================================================================================================================================
VAULTID || TEXTNAME || TEXT || DBMS_LOB.GETLENGTH(TEXT) || UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(TEXT,2000,1)) ||
======================================================================================================================================

VAULTID, TEXTNAME and TEXT are not a problem

but 

DBMS_LOB.GETLENGTH(TEXT) and UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(TEXT,2000,1))

are a whole different store. 

Simple custom manipulator with pilot scripting doesn’t work:
~ Rename(‘DBMS_LOB.GETLENGTH(TEXT)’, ‘BLOB_LOB_TXTLEN’);
~ Rename(‘UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(TEXT,2000,1)’, ‘BLOB_LOB_TXT’);

Best guess I have:
- Both the Dot notation and the Function like syntax contained in the property name are the issue.

Thanks