Re: Oracle/Web Communication Method

From: Anita M Wilcox <amw_at_world.std.com>
Date: 1998/11/03
Message-ID: <F1v1LC.5F3@world.std.com>#1/1

In article <3639C16B.CC7C55D5_at_micropat.com>, Fred J. Leskowitz <fred_at_micropat.com> wrote:
>We have Oracle 7.3.3.4 on NT currently receiving messages
>from our web via a SQL*Plus connection. Basically, the web
>keeps a pipe open to Oracle and puts sql commands or calls
>procedures/functions as needed. The results are screen scraped
>by unix shell utilities.
>
>This works fine for communication from web TO oracle.
>
>Can anyone suggest a method whereby Oracle on NT can
>send messages to the web?
>
>My thoughts so far:
>
>- use DBMS_FILE to write to a file, have unix watch for the file [slow?]
>
>- same, but append to a file, have unix treat the file as a "database"
>- use the pipe method, have unix screen scrape results
>- use the pipe method, have Oracle return results as HTML text document
>
>Any suggestions directions greatly appreciated.
>
>- Fred
>

Why not use CGI? Perl has some excellent Oracle interface modules (DBD::Oracle and DBI)

Anita Received on Tue Nov 03 1998 - 00:00:00 CST