Re: CGI call to an Oracle Server

Billy,

    Thanks for the information. I guess that I did not ask my question in a correct way. I basically need to some scripts in C or perl that does the database connection and getting results. I know if I search I can find plenty of examples but I thought asking the question at this newsgroup might give me a quick answer.

    Do you have any scripts handy? Particularly, do you have scripts that handle reading binary data (long raw field)?

    Thanks.

--Stephen

Billy Verreynne wrote:

> Stephen Wang wrote in message <38AB2A68.9C0E502B_at_flux.cpmc.columbia.edu>...
>
> > I am testing a CGI program that would call an Oracle 8i on a
> >different server machine. The CGI program could be either in C or Perl.
> >I would appreciate if someone could show me some scripts that do the
> >connection and get some data.
>
> A normal program reads the user input (criteria) from the keyboard, or a
> window containing input fields etc. Then it connects to the database, fires
> off a SQL statement, gets the data and the formats the data into an output
> window for the user.
>
> A CGI works for all intents and purposes the same way. The only differences
> are with the way the input and output are handled.
>
> User input is received via the operating system environment. The Web Server
> sets up environmental variables (like QUERY_STRING for example when doing a
> PUT) that contains the data that the user transmitted via his web browser.
>
> The output that is returned, must be in HTML format and written to the
> STDOUT (the standard output device). The Web Server reads the stuff that the
> GCI sends to STDOUT and passes that back as a dynamically created HTML page
> to the web browser.
>
> You need to understand how these basic concepts work, in order to write a
> CGI. The best is to leave the database part out of it all together for
> starters and try and develop a GCI that takes no input and simply returns
> the operating system date and time. The add input to it. Make the HTML
> output more complex. Then finally start looking at the db side.
>
> regards,
> Billy
Received on Fri Feb 18 2000 - 15:06:51 CST