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