Re: ASP and LONGs

From: Sean <dolans_at_my-deja.com>
Date: Wed, 24 Jan 2001 19:32:43 GMT
Message-ID: <94nakr$ljb$1@nnrp1.deja.com>

If what you are doing is trying to retrieve MASSIVE amounts of text, I will tell you what I did in a similar situation that was adequate for us.

Create a table:
ID

---

Content VARCHAR2(4000)
PAGE NUMBER(2) Naturally the challenging part is to get it INTO the table, but once you have it parsed appropriately and in the table, just return a REF CURSOR and loop through the RecordSet in ASP: open p_Cursor for

    select content from {tablename} order by page asc;

Do while not rs.EOF

   Response.Write(rs(0))
rs.MoveNext
Loop

That's one idea. The other is to use the Oracle Driver vs the Microsoft OLE DB/ODBC driver. I do remember seeing an example on one of the many Oracle sites, come to thin of it, I think it was on Oracle Technet's news groups on OLE Objects.

Hth,
Sean

In article <3a6c314b.84792975_at_news.twsn1.md.home.com>,   randalthor_at_camelyn.com (Rand 'al Thor) wrote:
> Thanks for the article. It dealt with RAW and LONG RAW datatypes. I am
> not an Oracle expert but I believe they are used like a BLOB in SQL
> Server for image data and the like. I think a LONG (not LONG RAW) is
> used for text. My problem is storing and retrieving large amounts of
> text > than the 4000k you can put in a VARCHAR2. I tried the Binary
> Write method as well as the GetChunck method and I have had probelms
> with each.
>
> BinaryWrite doesn't seem to work on type LONG. And I can use GetChunck
> and loop through a CLOB if it holds a lot of data. If I put only a
> small amount of data in a CLOB the GetChunck doesn't work.
>
> On Mon, 22 Jan 2001 05:56:23 GMT, Sean <dolans_at_my-deja.com> wrote:
>
> >Here is a link that will help:
> >
> >HOWTO: Retrieve RAW/LONG RAW Data from Oracle for ASP Page
> >http://support.microsoft.com/support/kb/articles/Q194/7/99.ASP
> >
> >Hth,
> >Sean
> >
> >In article <3a6b25ff.16353665_at_news.twsn1.md.home.com>,
> > randalthor_at_camelyn.com (Rand 'al Thor) wrote:
> >> Does anyone have a good example of retrieving and displaying a
> >> LONG datatype from Oracle in and Active Server Page using ADO. I am
> >> converting SQL Server text columns to Oracle and I am trying CLOBs
 and
> >> LONGs. VARCHAR2s only go up to 4000 bytes and I need more.
> >>
> >> Any help would be appreciated.
> >>
> >
> >
> >Sent via Deja.com
> >http://www.deja.com/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 24 2001 - 13:32:43 CST