| using LOBs [message #253304] |
Mon, 23 July 2007 07:37  |
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 #253437 is a reply to message #253304] |
Mon, 23 July 2007 23:18  |
 |
azamkhan
Messages: 557
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
