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'

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 06:10:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.