Create PL/SQL function and use it in the etl scenario. Use Oracle global variable