Re: Reading delimited text from a file

You could create a external table on the fly (dynamically) with specified delimiter and still read it like sql. Drop the ext table when done with it.

Raj

On 2/17/06, Jason Heinrich <jheinrich_at_pcci.edu> wrote:
> I'm not really looking to load data into tables, I just want to return some
> text from the specified file to the caller. I did consider using the
> external table approach and then just returning a row for each subsequent
> call, but that would prevent them from using a different delimiter than what
> they used on the first call. I don't know of anything that does that, but I
> suppose anything is possible... I've noticed that this also affects my
> GetBlockData function, which simple returns n characters from a file,
> because I'm using the same methodology: read n bytes of raw data and convert
> it to a string. (Yes, I do assume that the file uses a 1-byte character
> set, which in our case is safe).

--
----------------------------------------------
Got RAC?
--
http://www.freelists.org/webpage/oracle-l