ECDA Option for Oracle supports columns of datatype text and image when used with ASE. ECDA Option 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 ASE generates a select textptr() statement for a column, ECDA Option for Oracle creates a textptr value based on the Oracle ROWID. The text pointer is the actual ROWID of the given row.
When ASE requests a text or image column's text pointer using a select textptr() function, ECDA Option for Oracle will return a 16-byte binary column.
When inserting and updating text or image columns using ASE, use readtext and writetext commands for data lengths exceeding 16KB.
