Binary Files in OWB - Simple Example
By David Allan-Oracle on Jan 25, 2008
So how do you load binary data into Oracle? Using a variety of ways, thats the good news, this is a little like teaching new dogs old tricks. OWB's file support is rich enough to fulfill the vast majority of cases. I guess it is not 100% obvious though how it is done, especially from the queries on mailing lists and forums. Once you see the pattern then it becomes apparent what the tasks at hand are. I created a viewlet (see here) which uses a nice small example to illustrate how it all hangs together; what you can do with files and external tables. In 2007, a white paper was published that illustrated how to load COBOL
EBCDIC files using OWB's file support, check it out also (here). It illustrates how more complex data structures are represented and how to use OWB to complete the job. Must post the actual MDLs and data files for these too, its always useful to get your hands on something real.