DBD:CSV problem on Solaris

2006-06-28 Thread Govinda . Pfister
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

RE: CSV problem on Solaris

2006-06-28 Thread Garrett, Philip \(MAN-Corporate\)
-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

timestamp datatype

2006-06-28 Thread Loo, Peter # PHX
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

RE: CSV problem on Solaris

2006-06-28 Thread CAMPBELL, BRIAN D (BRIAN)
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

RE: timestamp datatype

2006-06-28 Thread Andy Hassall
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