Q: Simple Oracle query in Perl/CGI script on Windows95/NT?

What is the generally preferred method for querying an Oracle database in a CGI app written
in Perl, esp. when the CGI script is to execute on a Windows 95/NT platform?

1. ODBC?
2. SQL*Plus?

Regarding SQL*Plus, I have successfully:

1. By redirecting commands from a file obtained query results via the "backtick" syntax in Perl.
2. By opening a pipe sent commands to SQL*Plus, with results written to a file.

The problem with both approaches is that, under a multi-threaded Windows web server I don't
want to collide on the same filename handling 2 concurrent requests.

With UNIX one can get away with the "here" syntax in the shell, Windows doesn't seem to
have this.

Also Perl has a package for opening two pipes for both input and output (e.g. to SQL*Plus)
however they warn this is dangerous.

Any suggestions would be appreciated! Received on Mon Nov 03 1997 - 00:00:00 CST