DECLARE CURSOR c_schema IS select dschema from x.process_control where process_name = '....' order by schema; v_schema process_control.db_schema%TYPE; BEGIN OPEN c_schema; LOOP FETCH c_schema INTO v_schema; If v_schema <> '' then @connecting_schema v_schema; ???????????? EXIT WHEN c_schema%NOTFOUND; END LOOP; CLOSE c_schema; END;
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
26 Experts available now in Live!