Hello,
I do have a problem with a littler perl script I wrote.
It uses DBD:CSV and I don´t know why it doesn´t work as I would expect it.
After excuting the script it runs without output and ends without an error
message.
It should read a CSV-File and print it contents out to STDOUT.
I
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006 5:26 AM
To: dbi-users@perl.org
Subject: DBD:CSV problem on Solaris
Hello,
I do have a problem with a littler perl script I wrote.
It uses DBD:CSV and I don´t know why it doesn´t
Hi All,
I am getting the following error when I try INSERTing selected rows from
one database to another.
ORA-01843: not a valid month
Do I have to use to_date() and if so, has anyone done this with bind
variables?
I am using bind variables to INSERT the selected rows. Below is the
code
A bit OT, but assuming it's a linefeed issue...
UltraEdit does offer linefeed options.
You can convert files using File - Conversion - ...
You can tell it whether to load/save in the Unix format using Advanced -
Configuration - General.
-Original Message-
From: Garrett, Philip
You must tell Oracle what format your DATE or TIMESTAMP data is in, because
it's bound as a string, rather than the raw Oracle DATE or TIMESTAMP format.
This means you have to either:
(a) Explicitly state it in the SQL statement using TO_DATE(?, 'format') (or
TO_TIMESTAMP or TO_TIMESTAMP_TZ as