I currently use Oracle 10g and TOAD 184.108.40.206 and I am struggling with the display of LOB objects in TOAD. But it keeps showing this error message "A query with LOB's requires OCI8 mode, but OCI7 mode is used." I also tested the similar situation on PL/SQL Developer 220.127.116.116 with no problem. And of course, with MYSQL, displaying or manipulating LOB objects is just such an easy thing to do (for example, using PhpMyAdmin or DBACentral for mysql), in Oracle, however, you have to use Oracle DBMS_LOB packages to perform such tasks. Maybe do I need to configure Oracle in terms of OCI in order for TOAD to display LOB's properly?