Oracle loop

Oracle loop

DECLARE CURSOR c_drop IS
SELECT  table_name
FROM dba_tables
WHERE owner = '<sm séma neve>';
v_sql VARCHAR2(800);

BEGIN
    FOR r IN c_drop
    LOOP
        v_sql := 'DROP TABLE '|| r.owner||'.'|| r.table_name||' cascade constraints'                                                                              to prx_test';
        dbms_output.put_line(v_sql);
         BEGIN
           EXECUTE IMMEDIATE v_sql;
           EXCEPTION WHEN OTHERS THEN dbms_output.put_line(dbms_utility.format_error_backtrace );
         END;
    END LOOP;
END;
/