Home » SQL & PL/SQL » SQL & PL/SQL » HOW TO QUERY LOBS
HOW TO QUERY LOBS [message #20526] Fri, 31 May 2002 22:56 Go to next message
Naveed Bhagwani
Messages: 4
Registered: May 2002
Junior Member
HOW TO SELECT COLUMNS FROM A TABLE
HAVING LOB COLUMNS

HOW TO OVERCOME

THE ERROR IS 'INCONSISTENT DATATYPES'
Re: HOW TO QUERY LOBS [message #20583 is a reply to message #20526] Wed, 05 June 2002 21:26 Go to previous message
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
You will have to use DBMS_LOB package to read or write to lobs. More over if the lob is (particularly CLOB) is les than 4000 bytes then it can be stored inline.

ManishM.
Previous Topic: Error handling NEED HELP!
Next Topic: Re: PL/SQL Program Constructs
Goto Forum:
  


Current Time: Tue Nov 20 18:21:13 CST 2018