# HG changeset patch
# User Dorin Cobzac
# Date 1322105047 -7200
# Node ID 9d8363e2f7efb8996c54ec44483c3abec1663476
# Parent  3eaac5588b5c33e34e7d241131feecdc571d51c7
fix issue of crashing when using CallStoredProcedure.call() with NULL paramenters

diff -r 3eaac5588b5c -r 9d8363e2f7ef src/org/openbravo/service/db/CallStoredProcedure.java
--- a/src/org/openbravo/service/db/CallStoredProcedure.java	Mon Nov 21 18:59:47 2011 +0200
+++ b/src/org/openbravo/service/db/CallStoredProcedure.java	Thu Nov 24 05:24:07 2011 +0200
@@ -89,12 +89,12 @@
         final int sqlIndex = index + 1;
         if (parameter == null) {
           if (types == null || types.size() < index) {
-            ps.setNull(sqlIndex, Types.NVARCHAR);
+            ps.setNull(sqlIndex, Types.NULL);
           } else {
             ps.setNull(sqlIndex, getSqlType(types.get(index)));
           }
         } else if (parameter instanceof String && parameter.toString().equals("")) {
-          ps.setNull(sqlIndex, Types.NVARCHAR);
+          ps.setNull(sqlIndex, Types.NULL);
         } else if (parameter instanceof Boolean) {
           ps.setObject(sqlIndex, ((Boolean) parameter) ? "Y" : "N");
         } else if (parameter instanceof BaseOBObject) {
@@ -126,7 +126,7 @@
 
   private int getSqlType(Class<?> clz) {
     if (clz == null) {
-      return Types.NVARCHAR;
+      return Types.NULL;
     }
     if (clz == Boolean.class) {
       return Types.VARCHAR;