Re: Pro*C

You should always use the make file that is in the proc samples directory.(incude it in your program's make file). This make file contains all the libraries (and in the correct order!) you will need to link your programs.

Tom Zamani wrote:

> I went Through the manual and say that I need to include liboci.a in
> linking.
> But where is this file, I can not find it.
> Tom
> Peter Sylvester <peters_at_mitre.org> wrote in message
> news:382963CF.74C27E_at_mitre.org...
> > You need to link in the appropriate libraries. See the demo makefiles
> > that come with pro*c.
> > Peter
> >
> > Tom Zamani wrote:
> > >
> > > 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 Fri Nov 12 1999 - 00:53:54 CET