-- $Id: sym_util.sql,v 1.4 2004/03/11 21:26:04 jnasby Exp $

CREATE OR REPLACE PROCEDURE p( p_string in varchar2 )
IS
   l_string long default p_string;
   l_next int;
   l_add int;
BEGIN
	LOOP
		EXIT WHEN l_string is null;
		l_next := instr( l_string, chr(10) );
		IF l_next = 0 THEN
			l_next := 250;
			l_add := 1;
		ELSE
			l_next := l_next - 1;
			l_add := 2;
		END IF;
		dbms_output.put_line( substr( l_string, 1, l_next ) );
		l_string := substr( l_string, l_next + l_add );
	END LOOP;
END;
/
GRANT EXECUTE ON p TO public;

exec sym_build_util.clean_drop('TABLE config_partitions');
CREATE TABLE config_partitions(
	table_name			varchar(30) NOT NULL PRIMARY KEY
	, length_minutes	int NOT NULL
	, partitions_keep	int NOT NULL
	, last_run			timestamp with time zone DEFAULT to_timestamp_tz('1970-01-01 0:00', 'YYYY-MM-DD TZH:TZM') NOT NULL
);

CREATE OR REPLACE PACKAGE sym_util AUTHID CURRENT_USER AS
	PROCEDURE rotate_partitions;

	PROCEDURE exec_immediate(
		statement varchar
	);
END sym_util;
/
show err
GRANT EXECUTE ON sym_util TO public;

-- vi: noexpandtab sw=4 ts=4