removed DROP PROCEDURE queries and replaced with CREATE OR REPLACE for single query in transaction, refs #1020