MSCEWI3121
Using DBMS_LOB.SUBSTR built-in package with a BFILE column is not supported in Snowflake
Last updated
Using DBMS_LOB.SUBSTR built-in package with a BFILE column is not supported in Snowflake
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Medium
Oracle BFILE columns are migrated to VARCHAR in Snowflake. The file name is stored as a string in the new column. Therefore, using a SUBSTR function, in Snowflake, on the migrated column will return a substring of the file name. While Oracle DBMS_LOB.SUBSTR will return a substring of the file content. For more information review .
Review the documentation for handling files with Snowflake .
If you need more support, you can email us at