Kbase P138711: OpenEdge non mandatory blob field is created on the oracle as not null during the protoORA process
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/5/2009 |
|
Status: Unverified
SYMPTOM(s):
OpenEdge non mandatory blob field is created on the oracle as not null during the protoORA process
FACT(s) (Environment):
OpenEdge PRO/SQL tool also place a not null flag on the blob field
All Supported Operating Systems
OpenEdge 10.1C
OpenEdge 10.2x
CAUSE:
The DataServer cannot access a NULL BLOB column from Oracle Database. Therefore, the blob field is purposefully made "NOT NULL" on the Oracle Database. During the INSERT, we use the EMPTY_BLOB() Oracle function to initialize it to a NULL LOB locator.
FIX:
This is working as designed.