Re: HELP! - Need something to insert new CLOB to Oracle

[Quoted] Thanks. I took a look into the old archives and found your post, but unfortunatly it won't help me. I'm trying to achieve this from the client side, and have no access to the server (nor will the people I'm designing this program for) other than thru a programming interface I create myself so using PL/SQL to do this is not an option.

Also, I am loading this into interMedia and then indexing appropriately thru it.

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3D35F189.A3421AB_at_exesolutions.com>...
> Sybrand Bakker wrote:
>
> > On 17 Jul 2002 13:22:39 -0700, defrankc_at_yahoo.com (Chris D.) wrote:
> >
> > >Hello:
> > >
> > >I'm looking for any tips, examples, anything at all that would help me
> > >to figure out a way to add a CLOB to an Oracle database using my own
> > >application that I am developing.
> > >
> > >What I am trying to do is this: I am trying to transfer several
> > >hundred MBs worth of textual data into records in an Oracle database.
> > >I have this text data delimited already, but two of the "fields" are
> > >extremely large and thus need to be put into CLOBs (we are performing
> > >indexing on these fields once in Oracle as well).
> > >
> > >I can find no easy way to insert new rows that include CLOBs into the
> > >database. I have tried Visual C++ and the various Oracle tools
> > >available there and find that it does not work. I have also tried
> > >Visual Basic, and while I have gotten two programs working with it
> > >(one using ODBC and the other OO4O), VB seems to have a terrible time
> > >allocating, and more precisely de-allocating memory so I have a
> > >continuous memory leak that eventually brings down the program after
> > >it has run thru only about 100k records.
> > >
> > >I'm sure what I am doing is not unique, i.e adding new data records
> > >that include CLOBs to Oracle, and I am just looking for any help I can
> > >get as to what direction I should go to make this work. I've been
> > >banging my head off these various items for 3 weeks now to no avail.
> > >Thanks so much!!!
> >
> > You could have saved yourself 3 weeks of banging your head if you
> > would only have use the Oracle documentation with respect to the
> > dbms_lob package.
> > Also indexing a CLOB is a very bad idea, as that is what Oracle
> > Intermedia has been invented for.
> >
> > Hth
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
> And you can still find an example of all of the code needed to do this if
> you just search the google.com archives for the c.d.o. usenet groups. I
> posted it about three months ago.
>
> Daniel Morgan
Received on Thu Jul 18 2002 - 15:23:39 CEST