Re: Insert raw data into table

From: Fadila Mumbasic <fadila_at_seitz.de>
Date: 1995/12/19
Message-ID: <4b5rm7$g1d_at_sarajevo.seitz.de>#1/1

andalj_at_infmx (Andal Jayadharan) wrote:  

>I am new user of Oracle 7.0 and I am wondering as to how I could
>insert raw data into an Oracle table.
>
 

This is a part of my code to do it:

typedef struct {

        long len;
        char buf[MAX_SIZE];
        }long_varraw;

EXEC SQL type long_varraw is long varraw(MAX_SIZE);

main()
{
..
  long_varraw lvr;

....

fd=open("img.gif", O_RDONLY,0);
..
 nread=read(fd,lvr.buf,MAX_SIZE);
 if(nread<0)
 {

     ....
 }

 close(fd);

 lvr.len=nread;

 EXEC SQL whenever sqlerror do
   sql_error("Insert");

  EXEC SQL insert into img_table values(:img_id,:lvr);   EXEC SQL commit;
}

The second column of the table img_table is long raw

Best regards,

Fadila Mumbasic
SEITZ Gmbh, Pforzheim
Germany Received on Tue Dec 19 1995 - 00:00:00 CET