Transmission Problem?

[prycemat]

Hi,
Using Oracle SQL worksheet, I could up with an interesting problem. When I run my script remotely from my PC to the Database Server, my query creates an output file, in this case a TXT file. The file size when I run remotely is always half the size, as compared to when I run directly off the server.

Any thoughts?

 

[sem]

How about linesize? Do you use default value or reset it each time? The same with trimspool.

Regards, Dima

http://seminihin.narod.ru

 

[prycemat]

Well, the linesize is set for 300... here's the PL/SQL of the script

SET PAGES 0;
SET LINESIZE 300;
SET HEADING OFF;
SET FEEDBACK OFF;
SET TERMOUT OFF;

 

[sem]

Try to SET TRIMSPOOL ON. How about comparing content of both? What's the difference (rows, encoding, special characters)?

Regards, Dima

http://seminihin.narod.ru

 

[prycemat]

The content and layout appear to be the same, however instead of all of one month of data, it appears to vary from (end)date and not complete the one month

 

[sem]

Just an assumption: your NLS settings are different. In most cases it looks like you pass 01.02.2004 as DATE parameter and according to NLS_DATE_FORMAT it may be evaluated to either January 2 or Februaru 1. This error is not easy to pinpoint because an error is raised only for day (month!) numbers exceeding 12. The same issue (less frequently) may be with numbers (NLS_NUMERIC_CHARACTERS), as in some countries comma is used as fractional delimiter while in others - as triad separator.

Regards, Dima

http://seminihin.narod.ru