Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems with ASCII text files coming from Oracle

Status
Not open for further replies.

TAngel

Technical User
Apr 16, 2001
73
US
We anyone runs a file that is a .out files (ASCII TEXT) coming from Oracle have unrecognizable characters at the page break (even in standard reports our of the e-business suite. I spent some time last night and this morning googling and reading Oracle blogs/discussion threads related to Unix vs. IBM platforms and there is some reference as to how you save the text files, but nothing concrete. I am wondering if it's got something to do with our environment (Linux) possibly (setup).

Can someone help direct us to what the problem might be? We are running Oracle using Oracle's Hosting Services with OOD. They haven't been much help.
Teresa
 
TAngel,

What (commands/software/et cetera) are you using to create the ".out" file(s)?

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
The output (.out) files are created by Oracle applications and placing it under the $APPLCSF/out folder. There is no command to do it manually. We are using Oracle's e-Business Suite
 
If you are using some application (that generates the "*.out" files), then you have a couple of alternatives:

1) Contact technical support for the application and ask them how to suppress the page-break character string(s),

2) Post-process the output to strip off the undesirable page-break character string(s).

Let us know the "out"come. [wink]

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top