HPE Community
Operating System - HP-UX
1752717 Members
5534 Online
108789 Solutions
New Discussion юеВ

I need to redirect and capture the Oracle SQL output from a shell script I have...

 
SOLVED
Go to solution
Chris Elmore
Frequent Advisor

тАО08-30-2007 11:06 AM

тАО08-30-2007 11:06 AM

I need to redirect and capture the Oracle SQL output from a shell script I have...

Aloha Folks,

I need to use a UNIX redirect (HP-UX 11i) to capture my Oracle SQL output from a shell script I have... I get some of the output but not all of the output from the console session from my Oracle 10G SQL prompt. I am just using the standard in/out redirect '>' to redirect the output to a simple text file. Any suggestions? TIA!

Very Respectfully,
Chris Elmore
"Life is love and love is life"
0 Kudos
3 REPLIES 3
Ivan Ferreira
Honored Contributor

тАО08-30-2007 11:09 AM

тАО08-30-2007 11:09 AM

Solution

Re: I need to redirect and capture the Oracle SQL output from a shell script I have...

Have you tried:

script.sh > textfile.txt 2>&1

So you redirect the output and the error.
Por que hacerlo dificil si es posible hacerlo facil? - Why do it the hard way, when you can do it the easy way?
0 Kudos
Chris Elmore
Frequent Advisor

тАО08-30-2007 11:14 AM

тАО08-30-2007 11:14 AM

Re: I need to redirect and capture the Oracle SQL output from a shell script I have...

Aloha Ivan,

You hit it right on the mark. Thanks for the quick response! Take care.

Very Respectfully,
Chris Elmore
"Life is love and love is life"
0 Kudos
Chris Elmore
Frequent Advisor

тАО08-30-2007 11:15 AM

тАО08-30-2007 11:15 AM

Re: I need to redirect and capture the Oracle SQL output from a shell script I have...

ITRC rocks!
"Life is love and love is life"
0 Kudos
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.