Home » SQL & PL/SQL » SQL & PL/SQL » Re: Error in reading CLOB
Re: Error in reading CLOB [message #39121] Tue, 18 June 2002 09:25 Go to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
If you are going to use the function in a SQL context (as opposed to in a PL/SQL procedure), you can only return the first 4000 bytes of the CLOB. Change the second parameter in the call to dbms_lob.substr from 32767 to 4000.

Report message to a moderator

Re: Error in reading CLOB [message #39125 is a reply to message #39121] Tue, 18 June 2002 11:21 Go to previous message
Vinod
Messages: 76
Registered: April 1999
Member
Thank you very much, I got it

Report message to a moderator

Previous Topic: converting bytes to human friendly string`
Next Topic: exception
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 21:04:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.