10-23-2007
Unable to open .sql file
Hi,
Thanks for your reply.
I am using the following script. GetJobDetails is a script in unix. It assigns the value for JobCommand, $JobDesc and JobType. Then i am passing this sqlplus -s @"$JobCommand" > "${LogString}" 2>"${ErrorString}" command in IF loop.
The partial script is
==================================================
GetJobDetails
case $JobType
in
SQL)
InsertLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'START'
if ( PrereqsCheck ) then
print "$Step - $JobCommand > $LogString 2>$ErrorString"
if (time sqlplus -s @"$JobCommand" > "${LogString}" 2>"${ErrorString}" ) then
UpdateLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'COMPLETE' 0
else
UpdateLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'HALTED' 0
NotifyOperator 1 "$JobDesc" URGENT
fi
CompressInput
CompressOutput
fi
;;
esac
---------------------------------------------------
Thanks in Advance.
Regards,
Ananth P
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am trying to build a tuxedo server which in turn depends on several Pro*C programs. I am doing it on HP-UX system.
It looks to me that the ORACLE_HOME is set properly.
But I am getting error message when trying to build.
PCC-F-NOERRFILE, unable to open error message file, facility PR2
exit... (1 Reply)
Discussion started by: asutoshch
1 Replies
2. UNIX for Dummies Questions & Answers
Hi ,
We are running Oracle 8.1.7 on HP-UX B.11.00. Recently we have upgraded Oracle from 8.0.6. to 8.1.7. Almost all the shell script we use has the Sqlplus as sqlplus -s @/apps/prod/sql/xxxx.sql > /apps/prod/log/xxxx.out .
However we receive the error
SP2-0310: unable to open file... (2 Replies)
Discussion started by: guru_2007
2 Replies
3. Solaris
am unable to open a .log file which is 4MB size. (18 Replies)
Discussion started by: venkatramana
18 Replies
4. AIX
Hi All,
Can't find any documentation on the web for this anywhere, except about three web pages that are in Chinese.
When I enter SMIT on this box, I get
ERROR MESSAGE: Unable to open temp file
I suspected smit.log, but it is universal readable, writeable by root, and I am root.... (6 Replies)
Discussion started by: jeffpas
6 Replies
5. UNIX for Advanced & Expert Users
I am working on a unix server.
I killed all the processes with my id on the machine.
After that I tried to delete a file, I got an error:-
file not removed.Text File busy.
Deletion of directory prompted:-
Directory not empty.
Can anyone help me regarding this...???
Thanks,
Vikas (11 Replies)
Discussion started by: vikasrout
11 Replies
6. Shell Programming and Scripting
Hi,
I was compiling few C programs in the unix server and getting the following error message
rm: /home/a0xxx28/AVT/SEEDLIBRARYDB/LIB/*.a non-existent
proc MODE=ANSI CODE=ANSI_C INCLUDE=/home/a0xxx28/PVT/SEEDLIBRARYDB/INCLUDE
INCLUDE=/home/a0xxx28/PVT/SEEDLIBRARY/INCLUDE ... (1 Reply)
Discussion started by: kavithakuttyk
1 Replies
7. Red Hat
Hi,
I am unable to create/open any file in vi editor for normal user, though using root I am able to create/open any file, using redhat 5.5,
example
vi test
it showing nothing after entering command (9 Replies)
Discussion started by: manoj.solaris
9 Replies
8. Shell Programming and Scripting
Not able to open a file using this code
why not?
use strict;
use warnings;
my $file = "verInfo.txt";
unless(open FILE, $file) {
# Die with error message
# if we can't open it.
die "\nUnable to open $file\n";
}
my $line = <FILE>;
print $line;
close FILE; (7 Replies)
Discussion started by: srijith
7 Replies
9. Shell Programming and Scripting
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
10. UNIX for Beginners Questions & Answers
Hi,
Getting the below error while installing from ks.cfg unable to open input kickstart file curl#37 Couldn't open file /tmp/swappart
Here am trying to include /tmp/swappart file from pre section under disks and partition section. Dont know where exactly am doing wrong
My kickstart file... (3 Replies)
Discussion started by: Sumanthsv
3 Replies
LEARN ABOUT DEBIAN
parse::errorstring::perl
Parse::ErrorString::Perl(3pm) User Contributed Perl Documentation Parse::ErrorString::Perl(3pm)
NAME
Parse::ErrorString::Perl - Parse error messages from the perl interpreter
VERSION
version 0.15
SYNOPSIS
use Parse::ErrorString::Perl;
my $parser = Parse::ErrorString::Perl->new;
# or: my $parser = Parse::ErrorString::Perl->new(lang => 'FR')
# to get localized explanations
my @errors = $parser->parse_string($string_containing_stderr_output);
foreach my $error(@errors) {
print 'Captured error message "' .
$error->message .
'" in file ' . $error->file .
' on line ' . $error->line . "
";
}
METHODS
new(lang => $lang)
Constructor. Receives an optional "lang" parameter, specifying that error explanations need to be delivered in a language different
from the default (i.e. English). Will try to load "POD2::$lang::perldiag".
parse_string($string)
Receives an error string generated from the perl interpreter and attempts to parse it into a list of
"Parse::ErrorString::Perl::ErrorItem" objects providing information for each error.
SEE ALSO
splain
ACKNOWLEDGEMENTS
Part of this module is based on code from splain.
BUGS
Please report any bugs or feature requests to "bug-parse-errorstring-perl at rt.cpan.org", or through the web interface at
<http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Parse-ErrorString-Perl>. I will be notified, and then you'll automatically be notified of
progress on your bug as I make changes.
SUPPORT
You can find documentation for this module with the perldoc command.
perldoc Parse::ErrorString::Perl
o RT: CPAN's request tracker
<http://rt.cpan.org/NoAuth/Bugs.html?Dist=Parse-ErrorString-Perl>
o AnnoCPAN: Annotated CPAN documentation
<http://annocpan.org/dist/Parse-ErrorString-Perl>
o CPAN Ratings
<http://cpanratings.perl.org/d/Parse-ErrorString-Perl>
o Search CPAN
<http://search.cpan.org/dist/Parse-ErrorString-Perl/>
AUTHORS
o Petar Shangov, "<pshangov at yahoo.com>"
o Gabor Szabo <http://szabgab.com/>
o Ahmad M. Zawawi <ahmad.zawawi@gmail.com>
COPYRIGHT AND LICENSE
This software is copyright (c) 2010 by Petar Shangov.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.10.1 2010-11-29 Parse::ErrorString::Perl(3pm)