Pro*C

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 1999/11/10
Message-ID: <80avng$krg$1_at_perki.connect.com.au>#1/1

Can you help me please.
I have this Proc Program which will insert image in to database. when I do Proc filename.pc
gives me the filename.c
then
cc filename.c
which I get these errors

/tmp/ccXQIHcz.o: In function `connect':
/tmp/ccXQIHcz.o(.text+0x14e): undefined reference to `sqlcxt'
/tmp/ccXQIHcz.o: In function `sqlerror':
/tmp/ccXQIHcz.o(.text+0x211): undefined reference to `sqlcxt'
/tmp/ccXQIHcz.o: In function `insert':
/tmp/ccXQIHcz.o(.text+0x532): undefined reference to `sqlcxt'
/tmp/ccXQIHcz.o(.text+0x5b4): undefined reference to `sqlcxt'

Do you know why I am Getting these errors.

/*****Proc Program*****/

#define _HPUX_SOURCE /*This is necessary for HP platform*/
#define _POSIX_SOURCE /*This is necessary for AIX platform*/
#include <stdio.h>
#include <sys/file.h>
#include <string.h>
#include <fcntl.h>

EXEC SQL include sqlca;
EXEC SQL include sqlda;

#define TOTALSIZE 100000

typedef struct
{
 long len;
 char buf[TOTALSIZE];
}longvarraw;

typedef struct
{
 long len;
 char *buf;
}lvr_type;

EXEC SQL begin declare section;
 EXEC SQL type longvarraw is long varraw(100000); EXEC SQL end declare section;

void sqlerror();

/********************Connect**********************/

void connect ()
{
EXEC SQL begin declare section;
 char *uid="lmt0/lmt0_at_rock";
EXEC SQL end declare section;
EXEC SQL whenever sqlerror do sqlerror(); EXEC SQL connect :uid;
printf("connected\n");
}

/********************sqlerror()********************/

void sqlerror()
{
EXEC SQL whenever sqlerror continue;
printf("\nOracle Error!\n");
printf("%s.*s\n",sqlca.sqlerrm.sqlerrml,sqlca.sqlerrm.sqlerrmc); EXEC SQL rollback work release;
exit(1);
}

/********************int
read_file(filename,buf,bufsize)********************/

#define LOCALSIZE 512

int read_file(filename, buf,bufsize)
char *filename, *buf;
long bufsize;
{
char local_buffer[LOCALSIZE];
int n;
int total_size=0;
int in_fd;
in_fd=open(filename,O_RDONLY,0);
if (in_fd=-1)
 return -1;
while((n=read(in_fd,local_buffer,LOCALSIZE))>0) {
 if (total_size+n>bufsize)
 {
 close(in_fd);
 return -1;
 }
 memcpy(buf+total_size,local_buffer,n);
 total_size+=n;
}
close(in_fd);
return(total_size);
}

/********************int insert(key,file)********************/

int insert(key,file)
EXEC SQL begin declare section;
char *key,*file;
EXEC SQL end declare section;
{
EXEC SQL begin declare section;
longvarraw lvr;
EXEC SQL end declare section;
lvr.len=read_file(file,lvr.buf,TOTALSIZE); printf("length:%d\n",lvr.len);
if(lvr.len==-1)
 exit(fprintf(stderr,"Error while reading\n")); connect();
EXEC SQL whenever sqlerror do sqlerror(); EXEC SQL insert into tmp_image values(:key,:lvr); EXEC SQL commit;
printf("Inserted. \n");
}

/********************Main********************/

main (argc,argv)
int argc;
char **argv;
{
char all[TOTALSIZE];
int num_written;

if (argc==2)
 {
 insert(argv[1],argv[2]);
 }
else
 printf("Error");
} Received on Wed Nov 10 1999 - 00:00:00 CET