Re: Help ray with his oracle!!

"Ray Godfrey" <cord_u_roy_at_yahoo.com> 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??

where's the file? i assume it's on the client from where the jsp is requested (where the browser is running), and not on the server -- can you provide some more info? likely you'll use neither SQL*Plus nor SQL*Loader

looks to me that the first thing you need to do us upload the file to the database, then write a stored procedure to a) parse the file from the clob that is was loaded into, generating performing appropriate insert statement(s) or b) write the clob out to a file on the server, then access it via an external table

(my context is pl/sql web toolkit development -- i'm assuming the jsp would not be able to perform the read/parse/insert but that an HTML form with an INPUT field with TYPE=FILE)

;-{ mcs Received on Thu Mar 25 2004 - 16:22:45 CST