Home » SQL & PL/SQL » Client Tools » CLOB in OEM
CLOB in OEM [message #358885] Wed, 12 November 2008 18:26 Go to next message
evergrean
Messages: 15
Registered: February 2008
Junior Member
I am using OEM 9.2.0.1.0 and cant display CLOB data.
I can display the CLOB field names in the table but it doesnt show the CLOB field name and data when I view the actual data. It shows all the other field types and data but never CLOB. If I use SQL Plus I can view the CLOB data.

Please advise if there is a setting to change or why this is happening.

If I create a test table with just one field containing a CLOB datatype and I attempt to view the data it outputs this message in OEM:
VTOS-2011: Can not display contents of table 
with columns of type LOB, RAW, LONG RAW and OBJECT


Re: CLOB in OEM [message #358948 is a reply to message #358885] Thu, 13 November 2008 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OEM 9.2 does not support it.

Regards
Michel
Re: CLOB in OEM [message #359327 is a reply to message #358885] Fri, 14 November 2008 16:32 Go to previous messageGo to next message
evergrean
Messages: 15
Registered: February 2008
Junior Member
Thanks, does OEM 10g support it?
Re: CLOB in OEM [message #359343 is a reply to message #359327] Sat, 15 November 2008 01:06 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know I use SQL*Plus.

A good advice:
quoting Ana (anacedent):
Those who live by the GUI, die by the GUI.


Regards
Michel
Previous Topic: Spotlight on Oracle
Next Topic: SQL Plus Encoding Problem
Goto Forum:
  


Current Time: Wed Dec 07 16:48:38 CST 2016

Total time taken to generate the page: 0.14796 seconds