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

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
Littlefoot
Messages: 20888
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
azamkhan
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.

Regards,
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 Dec 02 18:23:09 CST 2016

Total time taken to generate the page: 0.20752 seconds