Re: Convert CSV data held in a CLOB into columns

In article <3a5e56ad-ddac-4d9e-a974-a7d9247250a3 @b1g2000pra.googlegroups.com>, EdStevens says...

> I'm puzzled. You say you would "like to be able to do all the work
> without any depdency on referencing files on the o/s", yet just before
> that statement you asked if you could "take the CLOB content, write it
> out via UTL_FILE then refer to it as an external table". Writing it
> via UTL_FILE and referring to it as an external table *is* referencing
> files on the o/s.

Sure - I realise that. As I said, I'd like to be be able to do it without using any external files. If that is not possible/practical then writing the uploaded file out and referring to it as an external table is option 2.

> And of course, you started with a file on the o/s -
> the file that you propose loading into a CLOB. Why not just reference
> *that* file as an external table?
>

The user will start with a file on the o/s - if they can upload that using standard file upload (using Oracle http server) then we can take it from there and automate the entire process.

We could allow a user to ftp a file to the server but that's messy (creating server accounts not linked to the application), no control over filenames etc. and still a need to log into the application to identify the uoloaded file and initiate some processing of it.

-- 
jeremy