Re: Need Help with LONG RAW

In article <4lbauc$26d_at_tabloid.amoco.com>,

   lhnelson_at_amoco.com (Lana Nelson) wrote:
>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 (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.

You cannot select a raw or long raw column using sqlplus. The only way I know  to see the contents of the column is to write a ProC program to fetch the data. You can refer to Sample 4 in the ProC directory. Received on Mon Apr 22 1996 - 00:00:00 CEST