Horsefeathers. You can use SQL Loader or External Tables, both of which are covered in the documentation..I know I have to use UTL _FILE but if someone could give me the code it would be great .
An external table will take less time to code than the equivalent UTL_FILE solution. It is unlikely anybody here is going to give you a PL/SQL program you can use because your requirements are bespoke.I have a deadlien to meet and don't have time to experiment with codes
I use it to mean "nonsense" but it's probably a euphemism for something stronger..BTW what's horsefeathers all about ?
jeneesh wrote:I've just split it off to a thread of it's own. ;)
And, please don't "hijack" 5 year old thread..Better start a new one..
I have a Clob file as a in parameter in my PROC. . File is comma separated.need procedure that would parse this CLOB variable and populate in oracle table .You don't have a "clob file" as there's no such thing. CLOB is a datatype for storing large character based objects. A file is something on the operating system's filesystem.