Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ASP and LONGs
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/
Received on Mon Jan 22 2001 - 07:17:31 CST