Kbase P42552: Workaround: JPEG image not correctly retrieved from Oracle d
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/09/2003 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
FACT(s) (Environment):
Progress 9.1B
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
Storing JPEG images into Oracle database with IMPORT UNFORMATTED.
A zero byte is added at the end of the data imported.
"Corrupt JPEG: 221 extraneous bytes before marker 0xd9" when opening the JPEG file.
Can not upgrade to Progress 9.1D
CAUSE:
Bug# 20020416-003
FIX:
The raw record can be truncated when retrieving it:
PUT CONTROL RAW(<Field>,1, LENGTH(<Field>) - 1 ).