SQL*Loader and binary data (ICON files)

I am at my wits end. I have been using SQL*Loader for text files for years with no problem. I need to load binary data (icon files) into an Oracle 7.1.3 database running on Windows NT. I use SQL*Loader on a client WFW machine.

Scenario (1):

   ICON table:

      icon_name   varchar2(30)
      icon_field  long raw

   ICON CTL file:
      Load data
      append
      into table icon_table
      (icon_field position(1) raw (766))

   Windows File Manager: states size of file is 766

I have tried increasing and decreasing size of file, using Position(*) and every other possible combination to no avail. (The above should work) I get OSD ???? Unable to read complete file. (sorry I cannot remember error number and am at home).

Scenario (2):

   Export Oracle 6.0.36 database for a user with several tables.    Use kermit to do a binary transfer of file to PC.    Create Database and tablespaces similar in size and structure

       on Personal Oracle 7
   Attempt to use SQL*loader to load in.

• For each table found, get message .... skipping table tablename1 ..... skipping table tablename2
• Then get invalid syntax, or unknown command - much later.

   How can I force Oracle to recognize that this is from Oracle 6???

Please let me know, if you have any ideas, suggestions, sympathy.

TIA - Babette Dale Underwood (dale_at_fox.nstn.ca) Received on Fri Mar 22 1996 - 00:00:00 CET