Re: Oracle and Pro*C
Date: Thu, 26 Oct 2000 20:36:44 +0200
Message-ID: <8t9tlt$141$1_at_bw107zhb.bluewin.ch>
Hi,
first of all, do you have Oracle 8i or 8 ? If you start SQLPlus, do you get
....8.1.5 or do you get something like 8.0.5.
If you have 8i, you have to install client software from the CD and select
the Programmer Option. After the installation, you'll find in
$ORACLE_HOME/bin the file proc.exe That's the file which you have to start.
If you have Oracle 8.0.5 or less, there's a CD which is called Oracle Programmer which includes the stuff you're are looking for.
Yes, you'll need also a C compiler like VisualC ++ or Borland. You write a C programm with, let's say, special macros and then precompile it with the proc. The result file has to be compiled with the C compiler. Finally you gonna link the libraries together with your objectcode. Look in the proc directory and you'll find some demos. Look at the emp sample, which gives you a good starting point.
By the way, why do you want to use cgi progs. This means, you'll gonna start external processes, which can be very slow. As you said, you have allready installed the application server, so you may better use mod_plsql which is faster because it's running in the database.
cheers
eric
-- codewizarts i-solutions for tomorrow "JokeR" <zoran.civadelic_at_st.tel.hr> schrieb im Newsbeitrag news:8t4rph$3rid$1_at_as121.tel.hr...Received on Thu Oct 26 2000 - 20:36:44 CEST
> Hi!
>
> I'm new to Oracle, and need to make something like this (studying
purposes):
>
> On one (client) side I need to have .html (or something like) and on the
> other (server) side, I need to have a running Oracle database, and make
some
> cgi programs in C that will parse an input from .html (javascript) and
write
> into/read from Oracle database.
>
> So, I have installed Oracle 8 on NT, and also Application server. There is
> also Proc80 (I assume this is Pro*C/C++) directory in the installation,
but
> I don't know how to install it (there is no "setup" or "install" files nor
> anything like that).
>
> Can anyone give me some directions how to start using Pro*C/C++?
> And, also... is there a compiler included there, or can I just get some
> .lib's from the package and use something like Borland compiler?
>
> Thanks in advance!
>
>