Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using C variables as host variables in Pro*C program
Why not just use the old 734 client to run against the 817 database ?
"Pete's" <empete2000_at_yahoo.com> wrote in message
news:6724a51f.0303210643.1d39810c_at_posting.google.com...
> Maybe, have you checked out the Pre-compiler versioning? It's been a
> while, but, I believe you are able to set a version compatability in
> the Pro*C pre-comiple.
>
> HTH,
> Pete's
>
>
> aviles94_at_rcn.com (Enrique) wrote in message
news:<ca9fa791.0303201351.664490d3_at_posting.google.com>...
> > I had the "honor" of inheriting some old Pro*C programs that were
> > written and compiled under Oracle 7.3.4. One of the programs has a C
> > struct declared in a header file. The C struct is used directly on SQL
> > statements like this:
> >
> > EXEC SQL
> > SELECT column1
> > INTO struct_name->element1
> > FROM table_name
> > WHERE some_condition;
> >
> > This compiles and works well under Oracle 7.3.4. Since this is old
> > code and everything else we have is in Oracle 8.1.7 I tried to compile
> > the old code with Oracle 8.1.7 libraries. I got numerous errors about
> > undefined host variables on SQL statements like the one above. Can I
> > use C variables as host variables in Oracle 8.1.7??? I want to think
> > that it is possible since it works in the older version. I *have* to
> > compile the old code with Oracle 8.1.7 because it calls functions that
> > are located on external libraries that were compiled with Oracle
> > 8.1.7. When I run the old code compiled with 7.3.4 it fails with the
> > following error:
> >
> > 02127, 00000, "Precompiler/SQLLIB version mismatch"
> > // *Cause: The program was linked to an older version of SQLLIB, which
> > is
> > // incompatible with this release of the Oracle Precompilers.
> > // *Action: Relink the program with a newer version of SQLLIB
> >
> > The code found in the external libraries was compiled with Oracle
> > 8.1.7 so the program fails with this error as soon as it tries to call
> > the library function.
> >
> > Is there an easy way to make the old code (that uses C variables as
> > host variables) compile with 8.1.7?? Any precompiler option that I
> > need to set?
> >
> > Any help will be appreciated.
> >
> > E.
Received on Fri Mar 21 2003 - 10:00:07 CST
![]() |
![]() |