DirectConnect for Oracle supports columns of datatype text and image when used with Adaptive Server Enterprise. DirectConnect for Oracle provides text pointers, which are handles that reference text or image values in readtext, writetext, and select commands.
Sybase text and image columns are similar to the Oracle CLOB and BLOB columns. When Adaptive Server Enterprise generates a select textptr() statement for a column, DirectConnect for Oracle creates a textptr value based on the Oracle ROWID. The text pointer is the actual ROWID of the given row.
When Adaptive Server Enterprise requests a text or image column's text pointer using a select textptr() function, DirectConnect for Oracle will return a 16-byte binary column.
When inserting and updating text or image columns using Adaptive Server Enterprise, use readtext and writetext commands for data lengths exceeding 16KB.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
