Kbase P76903: How VARCHAR2 is being sized for an array that has the SQL-WIDTH set?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/02/2005 |
|
Status: Unverified
GOAL:
How VARCHAR2 is being sized for an array that has the SQL-WIDTH set?
GOAL:
How does Oracle dataserver size VARCHAR2 for an array that has the SQL-WIDTH
set?
FACT(s) (Environment):
DataServers
FIX:
Following is the algorithem that is used to size an array extent
(Foreign database character field length, varchar2 for oracle)=
(SQL-WIDTH - 2x #of extents)/ #of extents
For example, if the SQL-WIDTH is 150, and you have 10 extents, the oracle field will be created as varchar2(13).