0038705: DB Functions returning CLOB type are not supported in Oracle

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0038705

Openbravo ERP

Y. DBSourceManager

public

2018-06-05 17:02

2022-02-01 08:08

Reporter

caristu

Assigned To

Triage Platform Base

Priority

high

Severity

minor

Reproducibility

have not tried

Status

acknowledged

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

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

0038705: DB Functions returning CLOB type are not supported in Oracle

Description

Currently it is possible to define functions that return the text type in PostgreSQL. When exporting such functions in Oracle, this return type is stored as CLOB within the xml definition.

But when installing a function like that in Oracle an error is thrown during update.database task.

Steps To Reproduce

1) Apply the attached patch
2) Using PostgreSQL, execute ant smartbuild -Dlocal=no. OK
3) Using Oracle, execute ant smartbuild -Dlocal=no. It fails.

Proposed Solution

The return type is exported as CLOB. This type is currently not being mapped properly for Oracle by DBSM.

- Postgres type mapping: https://code.openbravo.com/erp/devel/dbsm-main/file/tip/src/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java#l69 [^]
- Oracle type mapping: https://code.openbravo.com/erp/devel/dbsm-main/file/8d1a581a7dcb/src/org/apache/ddlutils/platform/oracle/OraclePlatform.java#l87 [^]

Decide how to map it

Additional Information