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: 20848
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: 548
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: FRM 40735:WHEN-BUTTON-PRESSED Trigger Raised unhandled Exception ORA - 305500
Next Topic: Need help in Oracle Forms (merged)
Goto Forum:

Current Time: Fri Oct 21 04:29:25 CDT 2016

Total time taken to generate the page: 0.08667 seconds