Re: CLOB contents

On Mon, 2007-02-05 at 15:34 -0300, Joshua Tagnore wrote: > List, > > I'm having a problem solving a quite trivial matter. I want to > "SELECT" the content of a CLOB. For example: > > SELECT getContent(FILETOCLOB('/filename','server'))... > > The issue here is that "getContent" doesnt exists ( its just an > example for explaining my problem ), and I havent been able to find > something that does that... Something I tried was: > > SELECT FILETOCLOB('/filename','server')::LVARCHAR ... > > But this returned the clob identifier. The question is : "how do i > get the contents of a clob?" You're not saying what client application or API you're using. The only method that'll work universally (as far as I know) is to use the LOTOFILE function to write the CLOB contents into a file. If that doesn't fit your idea of "get the contents" then you're going to have to explain what you are trying to accomplish and what client application/API you're using. -Carsten