Re: Dynamic SQL and Pro*C

Hello,
I have three system, Windows 2000 server and Intel Solaris 8.1.7 UNIX Server and HP-UX Server.

Environment.
Windows 2000 Server.

• Oracle Programmer install including Pro*C.
• Setup tnsnames.ora Intel Solaris 8.1.7 UNIX Server
• Oracle 8i Database.
• Setup tnsnames.ora anf listener.ora HP-UX Server
• Oracle 7.3.4 Database
• Setup tnsnames.ora anf listener.ora
  1. Can I access Oracle 8i and ORACLE 7.3.4 using Proc*C in Windows 2000? If so, how could I program? EXEC SQL CONNECT USER BY PASSWD_at_SERVICENAME is this code is correct?

"Shirland Leader" <vvega_at_akula.com> wrote in message news:3D642F21.35721E32_at_akula.com...
> Hello,
> I'm a novice pro*C programmer. I have come upon a problem that I
> cannot resolve. When running a query via a string host variable , Must
> I use place holders for string variables/numbers etc in teh actualy
> queury ? I really dont want to ! My data is built around really large
> structures and I dont know think Dynamic SQL supports
> Example...
>
> This is what I want to execute:
>
> char *stmt="SELECT EMPNO, EMPNAME where DEPTNO=34";
>
> It seems like im being forced to :
>
> int x=34;
>
> char *stmt="SELECT EMPNO, EMPNAME where DEPNO=:x";
>
> My program generates a statement like the first one above and its
> dynamic therefore I'll never know how many variables to declare. I've
> tried using a host array with the value in it but that doesnt seem to
> work for SELECT statements. Thanks in advance for any help !
>
Received on Fri Aug 23 2002 - 06:28:52 CEST