Post reply

Working with Oracle and CLOBs

  • 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]

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply