I have no problem connecting to an Oracle 8.1.5 database on Netware 5.1 and
viewing the contents of the database, however, add or editing are causing me
problems.
Here is my test code:
#!c:\perl\bin\perl.exe
use CGI;
use DBI qw(:sql_types);
$query = CGI::new();
if (($query->request_method() eq
Do you have some date data types in your db which are used in the insert?
If yes you need to use to_date() sql function in your query.
To format the date/hours.
Ilya Sterin
-Original Message-
From: Mitch Clarvit
To: [EMAIL PROTECTED]
Sent: 3/12/01 11:33 AM
Subject: Connecting to An
On Mon, Mar 12, 2001 at 01:33:25PM -0500, Mitch Clarvit wrote:
> I have no problem connecting to an Oracle 8.1.5 database on Netware 5.1 and
> viewing the contents of the database, however, add or editing are causing me
> problems.
> $sql = "INSERT INTO courses (CourseID, Title, Fees, Hours
Gentlemen:
I have struggled with this problem for a while now with no success at
finding the answer, so I am asking for help from anyone who might know
the solution.
I am using Windows XP, ActiveState Perl 5.8.4, Oracle 9.2.0.1.0 client
and server, DBI (1.45) and DBD-Oracle (1.16) installed
Hi Charles,
Try setting your environment variables in a BEGIN block, like this:
#!/usr/bin/perl -w
use strict;
BEGIN {
$ENV{'NLS_LANG} = 'american';
$ENV{ORACLE_HOME} = 'D:\Oracle\ora92';
}
### the rest of your code goes here ###
I haven't done Perl/DBI/Oracle in quite a while, but that's w
It's probably worth pointing out here that the use of the BEGIN block
*IS* described in the DBD::Oracle perldocs - as the perldocs are
included when you install any module, after you install DBD::Oracle you
can do
perldoc DBD::Oracle
to read the excellent perldocs. Look for the paragraphs tit
:[EMAIL PROTECTED]
Sent: Tuesday, January 18, 2005 12:55 PM
To: dbi-users@perl.org
Subject: Problem with connecting to an Oracle database using Perl
Gentlemen:
I have struggled with this problem for a while now with no success at
finding the answer, so I am asking for help from anyone who might
55 AM
To: Hardy Merrill; dbi-users@perl.org; [EMAIL PROTECTED]
Subject: Re: Problem with connecting to an Oracle database using Perl
It's probably worth pointing out here that the use of the BEGIN block
*IS* described in the DBD::Oracle perldocs - as the perldocs are included
when you install a