11-12-2004
Could u try putting 'exit' after EOF ??
Also , try ';' after ORACLE statements whereever necessary .
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Any link or example to write shell script for the Connecting Oracle for Quering through SQL
thanks in advance ...
Cheers !!
Mehul Doshi (3 Replies)
Discussion started by: mehuldoshi
3 Replies
2. Shell Programming and Scripting
Hi all,
I am running an sql file from unix .In the log file along with the output
i am getting details of connecting and disconnecting sqlplus like
It saves the output with "Connected to Oracle8i Enterprise Edition Release
8.1.7.4.0 Connected as apps" and "disconnected... (1 Reply)
Discussion started by: rrs
1 Replies
3. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
4. Shell Programming and Scripting
Hi I am getting this error while connecting to sql through a shell script, whereas i am able to connect to sql directly.
It was working properly earlier, no clue why i am getting this.
Please find the log below:
FTP to <IP> completed Wed Apr 30 11:42:01 BST 2008
Program ended. Wed Apr 30... (1 Reply)
Discussion started by: nehak
1 Replies
5. Shell Programming and Scripting
I've installed unixODBC and I would like to connect to a MS SQL (2005) database from a bash script. Can you post a code example?
Thank you! :D
J. (0 Replies)
Discussion started by: ph0enix
0 Replies
6. UNIX for Advanced & Expert Users
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
7. Shell Programming and Scripting
Hi, I have a file which contains the following data
File.dat
<filenum>
W10
</filenum>
<hello>Heading </hello>
I need to replace the contents of file.dat with
database value inplace of W10
Can some one please tell me how to search this <filenum>
W10</filenum>
and replace... (1 Reply)
Discussion started by: Ramyajiguru1
1 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
In a Shell scriipt with a SQL block I want to issue a query against a local DB and a remote DB on a remote server. The shell script is running locally.
This is how I connect to the local server. But I want the query to reference remote table in the join. Question can I specify a... (1 Reply)
Discussion started by: daveu7
1 Replies
9. Shell Programming and Scripting
I am connecting to sql databases through shell script. Databases that i am connecting will need password change every 60 days. This is according to our security policy and cannot be changed. But this is creating problem when connecting to Databases through shell script . To connect to oracle DB we... (2 Replies)
Discussion started by: pallvi_mahajan
2 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT SUSE
log::log4perl::resurrector
Resurrector(3) User Contributed Perl Documentation Resurrector(3)
NAME
Log::Log4perl::Resurrector - Dark Magic to resurrect hidden L4p statements
DESCRIPTION
Loading "use Log::Log4perl::Resurrector" causes subsequently loaded modules to have their hidden
###l4p DEBUG(...)
###l4p INFO(...)
...
statements uncommented and therefore 'resurrected', i.e. activated.
This allows for a module "Foobar.pm" to be written with Log4perl statements commented out and running at full speed in normal mode. When
loaded via
use Foobar;
all hidden Log4perl statements will be ignored.
However, if a script loads the module "Foobar" after loading "Log::Log4perl::Resurrector", as in
use Log::Log4perl::Resurrector;
use Foobar;
then "Log::Log4perl::Resurrector" will have put a source filter in place that will extract all hidden Log4perl statements in "Foobar"
before "Foobar" actually gets loaded.
Therefore, "Foobar" will then behave as if the
###l4p DEBUG(...)
###l4p INFO(...)
...
statements were actually written like
DEBUG(...)
INFO(...)
...
and the module "Foobar" will indeed be Log4perl-enabled. Whether any activated Log4perl statement will actually trigger log messages, is up
to the Log4perl configuration, of course.
There's a startup cost to using "Log::Log4perl::Resurrector" (all subsequently loaded modules are examined) but once the compilation phase
has finished, the perl program will run at full speed.
Some of the techniques used in this module have been stolen from the "Acme::Incorporated" CPAN module, written by chromatic. Long live
CPAN!
COPYRIGHT AND LICENSE
Copyright 2002-2009 by Mike Schilli <m@perlmeister.com> and Kevin Goess <cpan@goess.org>.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.12.1 2010-02-07 Resurrector(3)