#!/bin/sh

if [ $# -ne 1 ]; then
   echo "Usage: $0 <procedure sql file>"
   exit 1;
fi

SQLFILE=$1
DP_MON_PROC=dp_monitor_proc.sql

if [ ! -f ${SQLFILE} ]; then
   echo "${SQLFILE} does not exist"
   exit 2;
fi

# Procedure
cat ${SQLFILE} |  \
sed 's/procedure/create or replace procedure/I' | \
sed 's/end *;/end;\n\//I' \
> ${DP_MON_PROC}