Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sometimes Select External Table from CSV File Return No Rows
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
![]() |
![]() |