Working with Oracle and CLOBs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Working with Oracle » Working with Oracle and CLOBs

Working with Oracle and CLOBs

Rate Topic

Display Mode

Topic Options

Author

Message

chotmaranirpo

Posted Wednesday, September 23, 2009 2:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, September 23, 2009 2:05 AM
Points: 1, Visits: 0

I am using Weblogic 8.1 and Oracle 9i. I simply want to insert a CLOB into an Oracle
table

I pretty much know how to do this with an OracleConnection BUT the Connection
which i'm retrieving from my oracle datasource is some sort of Weblogic Wrapper
Connection which I cannot cast to an OracleConnection

So:

(1) If I have setup an Oracle Datasource (using a thin driver), when I retrieve
a connection why is this not of type OracleConnection?

(2) If I can't get access to the underlying OracleConnection, then can I insert
a CLOB using the Weblogic connection which i recieve?

formation informatique à distance

Post #792431

PaulB-TheOneAndOnly

Posted Wednesday, September 23, 2009 6:07 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:08 PM
Points: 2,982, Visits: 4,396

Answering your Oracle question... research DBMS_LOB system package.

LOB is such a complex subject it goes beyond what can be discussed in a post.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Post #792552

« Prev Topic | Next Topic »

Permissions