Re: Need some Pro*C advice (want to ditch SQL Loader)

Pro*C is a precompiler - that is you write your code in Pro*C which looks like
C with embedded SQL and when you run make the actual C program is produced and then compiled. For what you are talking about doing, you will need to write a
C loop and parse your load into INSERT statements. To insert a LONG RAW like
a .tiff file, you need to use an array and break it up into chunks. You can use gcc
as your C compiler, that is not a problem although the code you will need to write
is fairly sophisticated Pro*C. I know that Oracle support has some stuff that can
help you - if you have an account with them, I would advise contacting them.

Bob Hayden <bob.hayden_at_ljpc.com> wrote in article <5r0e36$csq_at_news.cerf.net>...
> Hello,
>
> I posted an article about importing graphics files using SQL Loader last
 week,
> but I did not get much response. Because of this, I have concluded not
 many
> individuals are using SQL Loader for much beyond text uploads. I am
 already
> writing utilities (in C) to process multiple text files and generate
 compact
> text files for SQL Loader, so now I am asking myself why I am even using
 SQL
> Loader if I could be using pro*c. This seems to be even more effective
 when it
> comes to loading my tiff image files (since SQL loader is just giving me
> headaches). I am an intermediate C programmer (with no C++) so will I be
 able
> to use pro*c, also what is pro*c? Is this a library that I can add on to
 gcc or
> is it a completly seperate compiler ( I am running HP-UX).
>
> Thanks,
>
> -Bob
>
>
> ----------------------------------------------------
> Bob Hayden bob.hayden_at_ljpc.com
> La Jolla Pharmaceutical Co.
> (619) 646-6699 ext.6807
> ----------------------------------------------------
>
>
Received on Thu Jul 31 1997 - 00:00:00 CDT