Support for Text and Image Datatypes

ECDA Option for Oracle supports columns of datatype text and image when used with Adaptive Server. 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 Adaptive Server 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 Adaptive Server requests a text or image column's text pointer using a select textptr() function, ECDA Option for Oracle returns a 16-byte binary column.

When inserting and updating text or image columns using Adaptive Server, use readtext and writetext commands for data lengths exceeding 16KB.

• Selecting Text and Image Datatypes
  Use select or readtext to select text and image datatypes.
• Updating Data
  Use the writetext command for writing text or image columns of more than 16KB.