关于oracle , SQLDA 的结构中 , BLOB 型是多少呀,

bsoeyx

关于oracle ,  SQLDA 的结构中 ,  BLOB 型是多少呀,
T[i] 的值的问题,
比如说  NUMBER =1, CHAR=96 ,

BLOB 型是多少呀,TIMESTAMP是多什么呀,各位谁知道的 有没有全的,给发一个,多 谢

-------
struct SQLDA
{
long N; /* Descriptor size in number of entries */
char **V; Ptr to Arr of addresses of main variables */
long *L; /* Ptr to Arr of lengths of buffers */
short *T; /* Ptr to Arr of types of buffers */
short **I; * Ptr to Arr of addresses of indicator vars */
long F; /* Number of variables found by DESCRIBE */
char **S; /* Ptr to Arr of variable name pointers */
short *M; /* Ptr to Arr of max lengths of var. names */
short *C; * Ptr to Arr of current lengths of var. names */
char **X; /* Ptr to Arr of ind. var. name pointers */
short *Y; /* Ptr to Arr of max lengths of ind. var. names */
short *Z; /* Ptr to Arr of cur lengths of ind. var. names */
};

llslls_007

回复 1# bsoeyx


   去oracle 官方 oci 手册 文档看 ：
  
  A LOB (Large Object) stores binary or character data up to 128 terabytes in length.
Binary data is stored in a BLOB (Binary LOB), and character data is stored in a CLOB
(Character LOB) or NCLOB (National Character LOB).
LOB values may or may not be stored inline with other row data in the database. In
either case, LOBs have the full transactional support of the database server. A database
table stores a LOB locator that points to the LOB value, which may be in a different
storage space.
When an OCI application issues a SQL query which includes a LOB column or
attribute in its select-list, fetching the result(s) of the query returns the locator, rather
than the actual LOB value. In OCI, the LOB locator maps to a variable of type
OCILobLocator.

去他们的论坛看 ，运气好，碰到热心的老外，会给你解答 oci的问题