Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sometimes Select External Table from CSV File Return No Rows

Re: Sometimes Select External Table from CSV File Return No Rows

From: gazzag <gareth_at_jamms.org>
Date: 22 Aug 2006 03:11:18 -0700
Message-ID: <1156241478.261080.76880@75g2000cwc.googlegroups.com>


Resant wrote:
> Sori, I've to post this problem again in this forum, 'cause I didn't
> get satisfied answer.
> My problem is :10id\fifi.soekianto client that submit their data in
> CSV file to central
> database. Then I use external table to get the data. It's works fine at
> all client except one!
> I can't select the external table from that client's CSV. The table
> show no returned rows.
> But when I open the CSV files and save directly without change
> anything, the external tables can show the data.
> I've check Excel version already and it's the same as other client.
> What should I do? Any clue?
>
> Thank you
>
> Resant

Is there any difference in the way you receive this file off this particular client? I'm wondering if you're experiencing an FTP issue. Maybe this one particular client is transmitting in binary instead of ASCII mode? Received on Tue Aug 22 2006 - 05:11:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US