I am in need of a form script that will allow for the collection of 5 items.. (1) Comment field (4) Hidden fields (Identifying information within the page itself.) It will: - Transfer the info to an Oracle7 database via TCP/IP. (With a time and Date stamp) - Redirect the submitter to a confirmation page. How can this be done? I have experience appending flat-file databases only. Thanks in advance.

## --/ SCRIPT CONFIGURATION /------------------------------- ## ## ## $dsn is the data source name we need to access the db, ## and takes the form of dbi:DRIVER:DATABASE where DRIVER ## is derived from the DBD::DRIVER modules and DATABASE ## is the name (and host if nedded) of the db we want. ## ## Sample DSNs are dbi:CSV:f_dir=/tmp/my_books (a CSV db), ## dbi:mysql:database=my_books;host=10.0.0.1 (a MySQL db ## hosted a different server), and ## dbi:Oracle:my_books (Oracle). my $dsn = 'dbi:CSV:f_dir=/tmp/mybooks';

# If someone has submitted a form with both the title and # author fields filled out, and the fields contain at least # one alphanumeric character if ( $cgi->param('title') && $cgi->param('title') =~ /\w/ && $cgi->param('author') && $cgi->param('author') =~ /\w/ ) {

Thanks for your help. I downloaded DBD::Oracle and it looks like I need to use Oracle.pm. Does that sound right to you? What else do I need? I should just require it at the top of my form processor script?

DBD::Oracle ( aka DBD/Oracle.pm ) is useless without DBI.pm, so you'll need to install that along with CGI.pm ( if you don't already have it ).

DBD::Oracle won't be called directly: that's done via the DSN you pass to the DBI module (ie, dbi:Oracle:database_name ), but you'll need to use or require both the DBI and CGI modules at the top of your script.

Oraperl was obsoleted by DBI and DBD::Oracle, so no, it is not necessary if you use the DBI method instead.

See my example.

It's heavily commented and fully functional. If you've paid attention to anything that's been said, you'll know that to get it running with an Oracle would only require changing one line in the entire script ( hint: my $dsn = 'dbi:..., you fill in the rest ).