PL/SQL getting binary_float data from a file

95 views Asked by At

I have a file on a Unix box that I need to read into my PL/SQL procedure. The file is 2904 bytes of data which it transpires is a contiguous string of 726 numbers of 4 bytes, so probably BINARY_FLOAT format, no line returns or new lines etc. I am struggling come up with the best way to read this data into my procedure, I eventually want to split it into 6 tables/collections each of 121 numbers. Any views or thoughts would be appreciated.

1

There are 1 answers

1
Dario Anibal Sabatini On

Use utl_file library, with it you can do many operations on files.