Unanswered: How to get LONG type object from Oracle to ASP?
I've got a problem with retrieving objects from Oracle table from LONG type column. Inside I have only text but a long one ex. 10 000 characters.
Problem is that recordset takes only first 100 characters from this field!
I've tried to use getChunk but unfortunately it didn't help.
I think that the problem is somewhere in Recordset because when I'm trying to get size of this field I always receive 100 :-(
below is fragment of my code:
set conn = server.createobject("adodb.connection")
Set rs = Server.CreateObject("adodb.recordset")
sql = "SELECT ID, name, description " &_
"from MyTable where ID=1"
Re: How to get LONG type object from Oracle to ASP?
I FOUND AN ANSWER!!!
Problem was in amount of tables inside my SQL statement. When there were 4 tables, alter join and I was retrieving 10 fields, then Recordset could not handle this and description was cut to 100 chars. But when I performed simple select from one table it worked OK.
So my advise is not to use to complicated SQL statement when fields can be big. In such a case you can use two queries. It will be slower but at least it will work!