WHENEVER oserror exit 1;
WHENEVER sqlerror exit 2;
SET HEADING OFF
SET FEEDBACK OFF
SET PAGESIZE 0
SET ECHO OFF
SPOOL ./tmp/retTables.txt
SELECT * FROM TABLE(usr.util_pack.Get_List);
SPOOL OFF;
exit 0;DECLARE
row_count NUMBER;
BEGIN
SELECT COUNT(line) INTO row_count FROM TABLE(usr.util_pack.Get_List);
IF row_count < 1 THEN
RAISE_APPLICATION_ERROR(-20000, 'Empty query result: tables list');
END IF;
END;
/
SELECT * FROM TABLE(usr.util_pack.Get_List);
Средний
Средний
