REGEXP_INSTR is a scalar function whose return value data type is: INTEGER if source_string is a CHAR or VARCHAR BIGINT if source_string is a CLOB