Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019162Openbravo ERPA. Platformpublic2011-11-24 03:232011-11-24 12:49
Reportericematrix3k 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS10OS Version
Product Versionmain 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019162: CallStoredProcedure crashes if callling with NULL parameters
DescriptionIn executing CallStoredProcedure.call() with NULL type paramenter, the function throws an 'Unknown Type' Postgresql Exception, thus rendering the function unusable.

Steps To ReproduceExecute the following code in a test environment:

CallStoredProcedure.call("c_order_post",null,null);

Expected: Error from function ERROR: @NotCorrectOrgDoctypeOrder@

Observed: An 'Unknown Type' exception.
Proposed SolutionUse Types.NULL when calling getNull();

I've attached a patch that fixes the problem,
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 00191643.0MP6 closed alostale Error when "CallStoredProcedure" receives empty string ("") in PostgreSQL 
Attached Filespatch main_rev14267.patch (1,442) 2011-11-24 03:23
https://issues.openbravo.com/file_download.php?file_id=4779&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-11-24 03:23icematrix3kNew Issue
2011-11-24 03:23icematrix3kAssigned To => alostale
2011-11-24 03:23icematrix3kFile Added: main_rev14267.patch
2011-11-24 03:23icematrix3kWeb browser => Google Chrome
2011-11-24 03:23icematrix3kModules => Core
2011-11-24 03:23icematrix3kIssue Monitored: icematrix3k
2011-11-24 12:49alostaleRelationship addedduplicate of 0019164
2011-11-24 12:49alostaleNote Added: 0043153
2011-11-24 12:49alostaleStatusnew => closed
2011-11-24 12:49alostaleResolutionopen => duplicate

Notes
(0043153)
alostale   
2011-11-24 12:49   
Duplicated of immediate issue 0019164