Hi there,
Hope someone will be able to help with that weird problem I'm facing.

I'm querying a CLOB field from an Oracle 8 DB, in an ASP page. I manage to retrieve the value of my CLOB field by using the GetChunk (the value is an HTML code).

My problem is that each time, the first 6 or 7 characters of my code are missing (but when looking directly in the DB, I see that the HTML codes in my table are fine).

For example, I've one of my code starting with :
<script language="JavaScript">
pp409217=window. open('','','scrollbars=no,resize=no,height=200,wid
th=350');

Once retrieved with GetChunk, I get :
language="JavaScript">
pp409217=window. open('','','scrollbars=no,resize=no,height=200,wid
th=350');

(<script is missing).

The code I use is :

sql_query = ""
sql_query = sql_query + " select text as code "
sql_query = sql_query + " from rendering"
sql_query = sql_query + " where id = " & id

'cnnprod is my connection object
set requete = cnnprod.execute(sql_query)
tempcod = requete.fields("code").getChunk(15000)
response.write tempcod

Does anyone have an idea of what would be causing the problem ?

Thanks

Salem