RANGER-2242: JiSQL utility is failing Oracle UDF
diff --git a/jisql/src/main/java/org/apache/util/sql/Jisql.java b/jisql/src/main/java/org/apache/util/sql/Jisql.java
index 9746a9a..b3e2725 100644
--- a/jisql/src/main/java/org/apache/util/sql/Jisql.java
+++ b/jisql/src/main/java/org/apache/util/sql/Jisql.java
@@ -429,6 +429,9 @@
if (trimmedLine.toUpperCase().startsWith("DECLARE")) {
commandTerminator="/";
}
+ if ((trimmedLine.toUpperCase().startsWith("CREATE OR REPLACE PROCEDURE")) || (trimmedLine.toUpperCase().startsWith("CREATE OR REPLACE FUNCTION"))) {
+ commandTerminator="/";
+ }
}
if(connectString.toLowerCase().startsWith("jdbc:postgresql") && inputFileName!=null){
if (trimmedLine.toLowerCase().startsWith("select 'delimiter start';")) {