Working with Oracle and CLOBs

• chotmaranirpo

  SSC Rookie

  Points: 27

  More actions

  September 23, 2009 at 2:09 am

  #211112

  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[/url]

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  September 23, 2009 at 6:07 am

  #1057431

  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.