473,320 Members | 1,950 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Writing to Windows using Oracle concurrent process to a defined mount point on Window

I have a process that generates a .txt file (fixed length) from an Oracle concurrent process. Originally, this was just picked up from a Linux directory and ftp'd to Windows directory. To automate the process, a mount point was established on the Windows server. The problem we are now seeing is that a control character (end of file) is seen at the end of each row. Can we do something in the program to control this? The problem is that the 3rd party software reading the file reads one row and then stops due to the control character.
May 14 '12 #1
3 1936
Rabbit
12,516 Expert Mod 8TB
How do you know it's printing a end of file character at the end of each row? Could it be that linux uses 1 character for a new line and windows uses 2 characters? And therefore the program never moves to the next row because it never finds those characters?
May 14 '12 #2
When we examine the file that was generated thru the mount point, you can see small box at end of row of information, immediately prior to next row of info. When 3rd party reporting tool brings this file in, it reads the first row and then sees end of file. I can only see this character in Windows XP, though. I am not sure how to see the details behind this small box so I can't answer your question if there is 1 character or 2 that make up the smal box.
May 14 '12 #3
Rabbit
12,516 Expert Mod 8TB
Exactly. It's unlikely it's a end of file character. A box merely means that it is an unprintable character. Use a hex editor to see what character it actually is. I am willing to bet it is a line feed character.

Linux uses only a line feed to represent a new line while windows uses a carriage return (CR) and line feed (LF). If your program is expecting to see both characters but your file only contains one of them, the program will error out. It's not because of an end of file character.

The solution is simple, whatever you're using to output the file, see if there's a setting to use a CRLF as the record delimiter. If not, as part of your automation, replace all LF with CRLF before running your other program.
May 14 '12 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Marco Vasquez | last post by:
Hi everybody, I would really appreciate any help in implementing Web Popup windows using User Interface Process Application Block. Thanks in advance, Marco
3
by: John Kuhn | last post by:
What additional steps are needed to allow web apps to access oracle ODP.NET resources under Windows Server 2003? When using Oracle's ODP.NET (9.2.0.401) from a WebForm I get permission errors...
0
by: Daniel Reber | last post by:
I am trying to start a process from a windows service but when the process starts the command window that the process runs in never shows. Is this because I am calling it from a windows service? ...
4
by: Jeremy Ames | last post by:
Is there a way, without using javascript, to open a new browser window at set the window attributes? I want to set the size, turn off the status bar, address bar, menu bar, and etc. Can someone...
1
by: Heiko Besemann | last post by:
Dear group, I created an aspx page using System.Diagnostics.Process() to launch "tracert" from shell and redirect output to Response.Output which prints it as text/plain into my browsers window....
2
by: satisharas | last post by:
Hello, I am trying to write a custom session manager in ASP.NET 2.0 using oracle as the backend. I want to know how the session expires in web garden and we are using NLB (a session can be...
0
by: george | last post by:
Hi world! Anyone experienced building gridview in Oracle environment using stored procedures, please help! Right now, I have issues using Oracle SP, I spent a whole day on this and still...
2
by: Diego F. | last post by:
Hello. I'm writing some code to connect and execute queries using oracle namespace in VB.NET. My question is about the use of transactions. To use oracle transactions, I must do something like:...
1
by: K. A. | last post by:
I'm in the process of upgrading my Oracle 8i to either Oracle 10g or even go straigt to Oracle 11g to use along with my PHP pages. My question is: is anyone using Oracle 11g with PHP 5 or even PHP...
1
by: Vinod Sadanandan | last post by:
Cross Platform Migration An Unproblematic Approach (Windows-UNIX ) Oracle 10\11g The principal restriction on cross-platform transportable database is that the source and destination platform...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.