Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Working with Oracle and CLOBs Expand / Collapse
Author
Message
Posted Wednesday, September 23, 2009 2:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, September 23, 2009 6:07 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
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 »

Add to briefcase

Permissions Expand / Collapse