Home » Developer & Programmer » Forms » using LOBs
using LOBs [message #253304] Mon, 23 July 2007 07:37 Go to next message
Messages: 5
Registered: July 2007
Junior Member

whenever i try to select any column containing LOB data type i recive message --

SP2-0678: Column or attribute type can not be displayed by SQL*Plus

how can i select or show the column containts from iSQL*PLUS
having LOBS
Re: using LOBs [message #253306 is a reply to message #253304] Mon, 23 July 2007 07:49 Go to previous messageGo to next message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Using the DBMS_LOB package?
Re: using LOBs [message #253437 is a reply to message #253304] Mon, 23 July 2007 23:18 Go to previous message
Messages: 551
Registered: August 2005
Senior Member
I dont think so that this should happen. I think that you are using SELECT * FROM table_name. Instide of using "*" use column makes except the LOB colmun b/c CLOB or BLOB are use to hold binary data so these types of column are not showed.

Azam Khan
Previous Topic: Creating and Populating A Tree
Next Topic: how to delete records
Goto Forum:

Current Time: Sun Aug 20 03:03:01 CDT 2017

Total time taken to generate the page: 0.04229 seconds