Re: Help ray with his oracle!!

cord_u_roy_at_yahoo.com (Ray Godfrey) wrote in message news:<1421dc84.0403251339.45481f9d_at_posting.google.com>...
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1078351617.911959_at_yasure>...
> > Ray Godfrey wrote:
> >
> > > i was wondering how to load a notepad file into a database with the
> > > click of a button on a jsp frontend. the notepad would have a list of
> > > people and their required attributes eg. ('543210', 'MARY', 'Earl',
> > > 'home', 'Place', 'JOSEPH');
> >
> > There are at least a half-dozen different ways. As you told us almost
> > nothing about the application I can't tell you which is best. In fact,
> > you didn't even tell us the version of Oracle.
> >
> > Myself ... I would use an external table or UTL_FILE but many other
> > approaches are possible.
>
>
>
> its sql plus, i've been to some sites but the explaination dosent
> really tell me where to place each part of the loader
> http://www.orafaq.com/faqloadr.htm#HOW
> like this,
> if i'm loading from a button in jsp, what do i do??

I could be wrong, but it doesn't sound like you know how to do the jsp part either. If you do, can you explain? When you create the jsp upload page, will the uploaded file end up on the web server or on the database server, or will you upload it directly into the database as a BLOB or CLOB?

As others have said, if the file ends up on the database server (file system), you can define an external table to read/load it.

If you load it into a blob/clob you can write pl/sql to parse it into structured data and insert into your appropriate tables. I have done this, so I can give more detail once you figure out how to get it into the database as a blob if that is your approach.

Dave Received on Thu Mar 25 2004 - 22:36:59 CST