Need Help with LONG RAW

Can someone help?

1. What is wrong with the table definition below?
2. Am I setting the bindsize correctly in sqlload? I assume the file is variable length, but I cannot edit it.
3. Why did I have to add 1 to the number of "rows to concatenate" to get the tiff file to load as one row?

Any info will be greatly appreciated including pointers to documentation (all I've found are bits and pieces here and there on long raw with no examples).
Please email lhnelson_at_amoco.com.

//////////////////////////////////////////////

SQL> create table tiff_files
  2     ( tiff_id       number,	
  3       tiff_file     long raw)

Table created.

SQL> desc tiff_files

 Name                            Null?    Type
 ------------------------------- -------- ----
 TIFF_ID                                  NUMBER
 TIFF_FILE                                LONG RAW

SQL> select tiff_id from tiff_files;

no rows selected

SQL> select tiff_file from tiff_files;
ERROR:
ORA-00932: inconsistent datatypes

no rows selected

/////////////////////////////////////////////

ls -l graphics.tiff


-rw-r--r--  1 zlhn01      92288 Apr 16 10:58 graphics.tiff

wc -l graphics.tiff
1371 graphics.tiff

more tiff.ctl

options(bindsize=93298)
load data
infile graphics.tiff
append
concatenate 1372
into table tiff_files
  ( tiff_id constant 1000,
    tiff_file raw (92288))

sqlload user/psw tiff.ctl

SQL*Loader: Release 7.0.16.4.0 - Production on Fri Apr 19 15:09:22 1996 Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.

Commit point reached - logical record count 1

SQL> select tiff_id from tiff_files;

   TIFF_ID

      1000

SQL> select tiff_file from tiff_files;
ERROR:
ORA-00932: inconsistent datatypes

no rows selected

Thanks....

Lana Nelson
Amoco
lhnelson_at_amoco.com Received on Sat Apr 20 1996 - 00:00:00 CEST