Out-params of EXECUTE IMMEDIATE in 11.2 cannot be BOOLEAN

pesse · pesse · commit ef68fc343f83 · 2019-01-15T22:33:57.000+01:00
diff --git a/src/main/java/org/utplsql/api/outputBuffer/OutputBufferProvider.java b/src/main/java/org/utplsql/api/outputBuffer/OutputBufferProvider.java
@@ -45,17 +45,17 @@ private static boolean hasOutput( Reporter reporter, OracleConnection oraConn )
         System.out.println("Checking Reporter hasOutput: " + reporter.getTypeName());
         String sql =
                 "declare " +
-                "   l_result boolean;" +
+                "   l_result int;" +
                 "begin " +
                 "   begin " +
                 "       execute immediate '" +
                 "       begin " +
-                "           :x :=' || DBMS_ASSERT.SQL_OBJECT_NAME( ? ) || '() is of (ut_output_reporter_base);" +
+                "           :x := case ' || DBMS_ASSERT.SQL_OBJECT_NAME( ? ) || '() is of (ut_output_reporter_base) when true then 1 else 0 end;" +
                 "       end;'" +
                 "       using out l_result;" +
                 "   exception when others then null;" +
                 "   end;" +
-                "   ? := case l_result when true then 1 else 0 end;" +
+                "   ? := l_result;" +
                 "end;";
 
         try ( CallableStatement stmt = oraConn.prepareCall(sql)) {
