View Incident Report

Serious

Reported By: Jurgen Sawatzki
Reported On: 7/11/2008
For: Version 2.00 Build 2

# 2698 External Function with VARCHAR Return Data Type Can Cause Truncation Error

I have the following external function. The SQL below results in the following error:

ElevateDB Error #202 An error occurred with the module ApxExt01 (ElevateDB Error #1011 An error occurred with the value <JOB>
<operation1>
<time>800</time>
</operation1>
<operation2>
<time>320</time>
</operation2>
</JOB>

(The value would result in truncation))

FUNCTION "JHSClobReadStrIdx" (IN "cbl" CLOB COLLATE ANSI, IN "ind" INTEGER)
RETURNS VARCHAR COLLATE ANSI
EXTERNAL NAME "ApxExt01"

select id, JHSClobReadStrIdx(sa, 1) from tab

Comments

This fix requires that both ElevateDB and the external module be recompiled using 2.01 or later.

Resolution

Fixed Problem on 7/11/2008 in version 2.01 build 1

Products Affected

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap