Re: Pulling LONG text to JScript ASP

I just did it - pulling LONG text from Oracle 8.0.4 db using ASP/IIS. I'm using VBScript but think it should also work with JScript. To me the key is to use Microsoft's ODBC driver for Oracle instead of Oracle's ODBC driver. When I used the latter, I got an error msg "A trappable error occurred in an external object."

One other thing, it seems that no drivers support pulling text from CLOB field when you try it with ASP/IIS. Oracle's SQL Plus can extract CLOB text. But using ASP/IIS to grab LONG text definitely works for me - with an MS ODBC driver.

Hope this helps.

Jeff Tang

In article <7f5ab9$udq$1_at_nnrp1.dejanews.com>,   torgojr_at_my-dejanews.com wrote:
> Hi, here is my problem : I want to pull the contents of
> ALL_TRIGGERS.TRIGGER_BODY, which is defined as LONG.
> I am using IIS 4.0, calling an Oracle 8.0.4 server over
> a network. I can select the entire record OK, but I
> can't assign a JScript string object (or any other
> object) to recordsetobj("TRIGGER_BODY"). It gives
> me a generic error message.
>
> Can I somehow pull the Trigger body text via ODBC to
> either JScript or VBScript to display on a web page?
> I don't see how to trick the recordset object into
> thinking that field is a VarChar or fixed Char field.
>
> Any input would be appreciated.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 29 1999 - 10:53:25 CDT