求助CLOB编程的问题

[复制链接]
查看11 | 回复0 | 2006-7-18 22:21:00 | 显示全部楼层 |阅读模式
我在使用数据库大对象编程的时候,发现采用:
OCIClobLocator *Lob_loc;
unsigned int Length;
EXEC SQL WHENEVER SQLERROR DO Sample_Error();
EXEC SQL ALLOCATE :Lob_loc;
EXEC SQL SELECT ad_sourcetext INTO :Lob_loc
FROM Print_media WHERE product_id = 3060 AND ad_id = 11001;
/* Opening the LOB is Optional: */
EXEC SQL LOB OPEN :Lob_loc READ ONLY;
/* Get the Length: */
EXEC SQL LOB DESCRIBE :Lob_loc GET LENGTH INTO :Length;
/* If the LOB is NULL or unitialized, then Length is Undefined: */
printf("Length is %d characters\n", Length);

EXEC SQL LOB READ :Amount FROM :Lob_loc INTO :Buffer;
int len=strlen(Buffer);
/* Closing the LOB is mandatory if you have Opened it: */
EXEC SQL LOB CLOSE :Lob_loc;
EXEC SQL FREE :Lob_loc;

执行结果发现:
printf("Length is %d characters\n", Length);
int len=strlen(Buffer);
2个长度不一致,为什么啊?
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行