Related to Issue 31119: Changes done in the Code Review.
authorDavid Miguelez <david.miguelez@openbravo.com>
Fri, 06 Nov 2015 13:56:58 +0100
changeset 27841 940048b0ab81
parent 27840 b0d1b3ab201c
child 27842 10ff05690b1a
Related to Issue 31119: Changes done in the Code Review.

Modified call to execute Warehouse Rule in M_Get_Stock_Param
in order to properly retrieve the OUT Parameters.
Previously it was throwing an exception always.
src-db/database/model/functions/M_GET_STOCK_PARAM.xml
--- a/src-db/database/model/functions/M_GET_STOCK_PARAM.xml	Wed Nov 04 21:20:09 2015 +0100
+++ b/src-db/database/model/functions/M_GET_STOCK_PARAM.xml	Fri Nov 06 13:56:58 2015 +0100
@@ -527,7 +527,7 @@
         IF (AD_GET_RDBMS() = 'ORACLE') THEN
           v_Sql := 'CALL ' || cur_warehouse.procedurename || ' (' || v_parameters ||', v_auxresult, v_auxmessage)';
         ELSE
-          v_Sql := 'SELECT ' || cur_warehouse.procedurename || ' (' || v_parameters ||') ';
+          v_Sql := 'SELECT * FROM ' || cur_warehouse.procedurename || ' (' || v_parameters ||') ';
         END IF;
         BEGIN
         IF (AD_GET_RDBMS() = 'ORACLE') THEN