Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028875Openbravo ERPA. Platformpublic2015-02-05 16:572024-05-28 10:46
Reportermalsasua 
Assigned ToTriage Platform Base 
PriorityhighSeveritymajorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028875: Class "CallStoredProcedure" does not support parameters of type out
Descriptionwith the class "CallStoredProcedure" if the stored procedure have got parameters of type out, it is not possible to read them, they are not returned

Also, in oracle, it is not possible to call a database stored procedure when the procedure have got parameters of type "out". Error is returned
Steps To Reproduce. in oracle and Web POS
. in OrderLoader.java the called to M_GET_STOCK_PARAM procedure:
 error is returned:
  
Caused by: java.lang.IllegalStateException: java.sql.SQLSyntaxErrorException: ORA-00904: "M_GET_STOCK_PARAM": invalid identifier
    [junit]
    [junit] at org.openbravo.service.db.CallStoredProcedure.call(CallStoredProcedure.java:142)
    [junit] at org.openbravo.retail.posterminal.OrderLoader.callProcessGetStock(OrderLoader.java:1795)
    [junit] at org.openbravo.retail.posterminal.OrderLoader.createShipmentLines(OrderLoader.java:860)
    [junit] at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:243)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00288343.0PR15Q2 closed umartirena Openbravo ERP M_Reservation_Post errors in oracle 
related to defect 0028909 closed marvintm Retail Modules can't create orders in Oracle 
has duplicate defect 0017018 closed marvintm Openbravo ERP DalStoredProcedureTest.testCallProcess fails only in Oracle 
has duplicate design defect 0036186 closed platform Openbravo ERP MA_PRODUCTION_COST procedure can not be call from OB in oracle instance using CallStoredProcedure 
related to defect 0031121 closed vmromanos Openbravo ERP Copy Version process in Process Plan window is not working in Oracle 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-02-05 16:57malsasuaNew Issue
2015-02-05 16:57malsasuaAssigned To => AugustoMauch
2015-02-05 16:57malsasuaModules => Core
2015-02-05 16:57malsasuaRegression level => Automated tests
2015-02-05 16:57malsasuaTriggers an Emergency Pack => No
2015-02-05 16:57malsasuaDescription Updatedbug_revision_view_page.php?rev_id=7631#r7631
2015-02-05 17:11AugustoMauchSummaryClass "CallSotredProcedure" does not support parameters of type out => Class "CallStoredProcedure" does not support parameters of type out
2015-02-10 11:04alostaleStatusnew => scheduled
2015-02-10 11:04alostalefix_in_branch => pi
2015-02-10 11:04alostaleAssigned ToAugustoMauch => alostale
2015-02-10 11:04alostaleRelationship addedrelated to 0028834
2015-02-10 17:17alostaleIssue cloned0028909
2015-02-10 17:19alostaleRelationship addedrelated to 0028909
2015-02-10 17:30alostaleNote Added: 0074331
2015-02-10 17:30alostaleStatusscheduled => acknowledged
2015-02-10 17:30alostaleTypedefect => design defect
2015-02-10 17:30alostaleTarget Version3.0PR15Q2 =>
2015-02-10 17:30alostalefix_in_branchpi =>
2015-02-24 11:12alostaleRelationship addedrelated to 0017018
2015-02-24 11:12alostaleRelationship replacedduplicate of 0017018
2015-02-24 11:13alostaleRelationship replacedhas duplicate 0017018
2015-03-04 18:23hgbotCheckin
2015-03-04 18:23hgbotNote Added: 0075168
2015-03-06 11:27eduardo_ArgalAssigned Toalostale => marvintm
2015-03-06 11:27eduardo_ArgalAssigned Tomarvintm => alostale
2015-10-19 12:16vmromanosRelationship addedrelated to 0031121
2017-04-10 14:35alostaleAssigned Toalostale => platform
2017-06-30 14:40caristuRelationship addedhas duplicate 0036186
2022-02-01 08:08alostaleAssigned Toplatform => Triage Platform Base
2024-05-28 10:46alostaleRegression levelAutomated tests =>

Notes
(0074331)
alostale   
2015-02-10 17:30   
Moving to design defect.

Current implementation supports to invoke procedures for which does not expect any return object or function in which case it expects an object to be returned. In this case it is invoking a procedure as a function throwing an error. See 0028909 for more details.

What needs to be checked/refactored:
* There are different ways of invoking procedures/functions: unify them
* Proper support for output parameters being DB agnostic
(0075168)
hgbot   
2015-03-04 18:23   
Repository: erp/pmods/org.openbravo.warehouse.pickinglist
Changeset: 24c46fe2335224c9ec749634d9223a9742da982a
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Mar 04 18:21:18 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/24c46fe2335224c9ec749634d9223a9742da982a [^]

Related to issue 28875
Class "CallStoredProcedure" does not support parameters of type out in oracle

---
M src/org/openbravo/warehouse/pickinglist/Utilities.java
---