Need Help with LONG RAW
Date: 1996/04/20
Message-ID: <4lbauc$26d_at_tabloid.amoco.com>#1/1
Can someone help?
- What is wrong with the table definition below?
- Am I setting the bindsize correctly in sqlload? I assume the file is variable length, but I cannot edit it.
- 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 (which I must have
missed) that has any EXAMPLES for handling
long raw.
Please email lhnelson_at_amoco.com.
////////////////////////////////////////////// SQL> create table tiff_files 2 ( tiff_id number, 3 tiff_file long raw)
4 /
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
On my system, the bindarray for 1 row is a max of 65536.
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