06-13-2005
I think if you simply add a - (minus) after the << it should ignore any tabs and whitespace it finds.
<<-SQPLUS
...
SQLPLUS
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
Discussion started by: kingluke
2 Replies
2. Programming
Hi to all,
I have a endday.sh file. And I execute this like "sh endday.sh" from command prompt. In endday.sh file it writes:
sqlplus temp/temp@data @run.sql&
echo $!>>pid.txt
However my aim is not to put the pid into pid.txt but I need to insert the pid into an oracle table using sqlplus.... (1 Reply)
Discussion started by: maverick1234
1 Replies
3. UNIX for Advanced & Expert Users
Hi to all,
I have a endday.sh file. And I execute this like "sh endday.sh" from command prompt. In endday.sh file it writes:
sqlplus temp/temp@data @run.sql&
echo $!>>pid.txt
However my aim is not to put the pid into pid.txt but I need to insert the pid into an oracle table using sqlplus.... (1 Reply)
Discussion started by: maverick1234
1 Replies
4. Shell Programming and Scripting
Hi to all,
I have a endday.sh file. And I execute this like "sh endday.sh" from command prompt. In endday.sh file it writes:
sqlplus temp/temp@data @run.sql&
echo $!>>pid.txt
However my aim is not to put the pid into pid.txt but I need to insert the pid into an oracle table using sqlplus.... (1 Reply)
Discussion started by: maverick1234
1 Replies
5. Shell Programming and Scripting
i am stuck with a problem ...
i have a shell script that gets the file name as input and performs the following operation...
it runs through a for loop inside from which i connect to sqlplus and run a procedure that creates a number of tables ..
there is no space in my server so we have made... (0 Replies)
Discussion started by: sais
0 Replies
6. Shell Programming and Scripting
Hi,
How to execute sql statements from the .sh file ??
Means, when we run .sh file then the sql statements within it should be get executed one by one from the sqlplus
With Regards (3 Replies)
Discussion started by: milink
3 Replies
7. Shell Programming and Scripting
Hi Experts,
There is a shell script that accepts positional parameter between 1-25 to execute case statement of script depending upon the parameter passed.
Now I need to run all the 25 sessions parallely. In each option of case statement it is connecting with sqlplus and executing a select... (11 Replies)
Discussion started by: Opamps123
11 Replies
8. Homework & Coursework Questions
Hi, I'm a complete novice to Linux and UNIX. I'm having trouble getting a script to execute properly. I did a similar script earlier in the semester with no problems. For whatever reason I can't get this one to work. Any help would be greatly appreciated as I'm completely lost and frustrated at... (5 Replies)
Discussion started by: Lindy70
5 Replies
9. Shell Programming and Scripting
i have 3 sqls , sql 1 and sql 2 shuld run in parallel , but sql 3 should run after completion f sql1 nd sql2, my code is as below, please suggest the changes
sqlplus username1/password1@DB1 @sql >> log1 &
sqlplus username2/password2@DB2 @sql2 >> log1 &
how can i execute the... (7 Replies)
Discussion started by: only4satish
7 Replies
10. UNIX for Beginners Questions & Answers
Hi Folks,
I have requirement to pull a bunch of SQL's from a table in DB and execute them in parallel and update the status of each query as and when they complete. Can you please help me with ideas on how this can be achieved?
create table list_of_sql
(
id number,
full_sql... (3 Replies)
Discussion started by: member2014
3 Replies
LEARN ABOUT OSX
log::message::handlers
Log::Message::Handlers(3pm) Perl Programmers Reference Guide Log::Message::Handlers(3pm)
NAME
Log::Message::Handlers - Message handlers for Log::Message
SYNOPSIS
# Implicitly used by Log::Message to serve as handlers for
# Log::Message::Item objects
# Create your own file with a package called
# Log::Message::Handlers to add to the existing ones, or to even
# overwrite them
$item->carp;
$item->trace;
DESCRIPTION
Log::Message::Handlers provides handlers for Log::Message::Item objects. The handler corresponding to the level (see Log::Message::Item
manpage for an explanation about levels) will be called automatically upon storing the error.
Handlers may also explicitly be called on an Log::Message::Item object if one so desires (see the Log::Message manpage on how to retrieve
the Item objects).
Default Handlers
log
Will simply log the error on the stack, and do nothing special
carp
Will carp (see the Carp manpage) with the error, and add the timestamp of when it occurred.
croak
Will croak (see the Carp manpage) with the error, and add the timestamp of when it occurred.
cluck
Will cluck (see the Carp manpage) with the error, and add the timestamp of when it occurred.
confess
Will confess (see the Carp manpage) with the error, and add the timestamp of when it occurred
die
Will simply die with the error message of the item
warn
Will simply warn with the error message of the item
trace
Will provide a traceback of this error item back to the first one that occurred, clucking with every item as it comes across it.
Custom Handlers
If you wish to provide your own handlers, you can simply do the following:
o Create a file that holds a package by the name of "Log::Message::Handlers"
o Create subroutines with the same name as the levels you wish to handle in the Log::Message module (see the Log::Message manpage for
explanation on levels)
o Require that file in your program, or add it in your configuration (see the Log::Message::Config manpage for explanation on how to use
a config file)
And that is it, the handler will now be available to handle messages for you.
The arguments a handler may receive are those specified by the "extra" key, when storing the message. See the Log::Message manpage for
details on the arguments.
SEE ALSO
Log::Message, Log::Message::Item, Log::Message::Config
AUTHOR
This module by Jos Boumans <kane@cpan.org>.
Acknowledgements
Thanks to Ann Barcomb for her suggestions.
COPYRIGHT
This module is copyright (c) 2002 Jos Boumans <kane@cpan.org>. All rights reserved.
This library is free software; you may redistribute and/or modify it under the same terms as Perl itself.
perl v5.16.2 2012-10-11 Log::Message::Handlers(3pm)