doberkofler

import hashlib
import re


def getOraclePackageSHA1(fileName):
	content = open(fileName).read()
	pattern = "(PACKAGE.*;)\s*/"
	compiled = re.compile(pattern, re.IGNORECASE | re.DOTALL | re.MULTILINE)
	match = compiled.search(content)
	if match:

doberkofler

CREATE OR REPLACE
FUNCTION getOraclePackageSHA1(theType IN VARCHAR2, theName IN VARCHAR2) RETURN RAW
IS
	TYPE aSourceType IS TABLE OF user_source.line%TYPE;

	aSource	aSourceType;
	aLob	CLOB;
	aHash	RAW(256);
	i		PLS_INTEGER;
BEGIN