BEGIN SELECT ls_live_schema||'_arc' INTO ls_from_user FROM dual; dbms_output.put_line(ls_live_schema); ls_sql:='Alter session set current_schema='||ls_from_user; EXECUTE IMMEDIATE ls_sql; -- ' || '' || -- ls_live_schema || '' || '_ARC'; --commit; SELECT sys_context('USERENV', 'CURRENT_SCHEMA') INTO ls_curr_user FROM dual; -- using ls_from_user; END;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)