Re: Pro*c : Remote Oracle Database Access using Pro*C

From: jacky <ritzcarltn_at_hotmail.com>
Date: Fri, 23 Aug 2002 05:15:11 +0900
Message-ID: <okM$KihSCHA.324@sql1.thrunet.com>

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?

"Fred" <fred_at_cf.fr> wrote in message
news:2002814-174733-108312_at_foorum.com...
>
> Hello,
>
> I can't find a way to insert a null integer value in Pro*C :
> eg, 'pid' is an integer, I would want to insert a NULL value, and not 0
>
> EXEC SQL
> INSERT INTO foo(cpt, code, dt, pid)
> VALUES (:cpt, :code, sysdate, :pid);
> EXEC SQL COMMIT;
>
> Thanks in advance.
>
> --
> Use our news server 'news.foorum.com' from anywhere.
> More details at: http://nnrpinfo.go.foorum.com/
Received on Thu Aug 22 2002 - 15:15:11 CDT