0004620: Create PriceList - Get PL/SQL Error - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0004620

Openbravo ERP

02. Master data management

public

2008-08-13 18:57

2008-10-08 17:48

Reporter

javiexpo1

Assigned To

gorka_gil

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.35MP5

Target Version

Fixed in Version

2.35MP9

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0004620: Create PriceList - Get PL/SQL Error

Description

When I am trying to modify my product prices creating a PriceList (CreatePriceList Button in Price List version Tab) for a new Price List Version applying to it a new Price List Schema i got this error message:

Error:
invalid input syntax for type numeric: """

This error raise from the PL/SQL store procedure named m_pricelist_create, and i think that the application is sending the parameters pInstanceID in an incorrect type format.

I could debug the application using Eclipse and i could see that in the line 307 of the method process103 "M_PriceList_Create" of the ActionButtonData class, there is a call for the method:

RDBMSIndependent.getCallableResult(null, connectionProvider, strSql, parametersData, parametersTypes, 0);

Inside of this method in line 63 theres is a call for the method:

UtilSql.setValue(st, iParameter, 12, "Test", parameters.elementAt(i)), that is using the number 12 hardcoded in order to define the type of the variable, if you see the class UtilSql.java the type of the variable 12 means that is a String and this is wrong because the PL/SQl Procedure M_PRICELIST_CREATE() is waiting for the pInstance value that is a variable type numeric nor string.

Steps To Reproduce

You can reproduce it in Openbravo ERP 2.35MP5 or 2.40Beta: triying to create a new Price List Version from an old Price List Version applying a Price List Schema, this is a standard transaction in Openbravo ERP.

Proposed Solution

Additional Information