Thread: Returning CLOBS

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Posts
    9
    Rep Power
    0

    Returning CLOBS


    I am currently using OraAccess TOraAccessStoredProc Components to return Result Sets. Currently, the database has a number of CLOB fields. When I try and open the StoredProc I receive a "Datatype not supported error". Does Anyone know a way I can retireve CLOB DataTypes?
  2. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,595
    Rep Power
    4207
    I've read somewhere that using a Microsoft driver to connect to oracle causes this, because the microsoft driver doesn't support CLOBS, NLOBS etc. Oracle's own driver does support CLOBS just fine though, so try using that instead.
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo

IMN logo majestic logo threadwatch logo seochat tools logo