|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
help me in sending parameters from sqlplus script to unix shell script
Post 302097404 by anbu23 on Friday 24th of November 2006 06:12:34 AM
11-24-2006
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies
2. Shell Programming and Scripting
Hi,
I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.
For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?
--------------------------------------------------------... (1 Reply)
Discussion started by: Jtrinh
1 Replies
3. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
4. Shell Programming and Scripting
Hi there
I'm new to UNIX scripting; I’m stuck with the following
I have an Oracle SQL script that takes three parameters
1- File Name
2- File Path
3- File creation date
Under UNIX I have a folder where files will be placed frequently and I need to upload those files to Oracle, what I need... (3 Replies)
Discussion started by: windjashi
3 Replies
5. Shell Programming and Scripting
Hi all,
I am using the below given sqlplus command in my unix script to invoke a stored procedure which returns a value .It works fine.
RET_CODE=$(/opt/oracle/product/10.2.0.4.CL/bin/sqlplus -S $USER/$PASSWD@$DB_NAME <<EOF
EXEC MY_PKG.MY_SP (:COUNT);
PRINT COUNT;
commit;
... (6 Replies)
Discussion started by: Shri123
6 Replies
6. UNIX for Dummies Questions & Answers
I want to execute a shell script from sqlplus prompt and get its output back to sqlplus. Is this possible?
if yes just give me an example for doing that. (2 Replies)
Discussion started by: boopathyvasagam
2 Replies
7. Shell Programming and Scripting
Gurus,
The issue I'm having is that my Shell won't accept SQL parameters properly......
Here's they way I'm running it....
applmgr@ga006hds
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
Discussion started by: WhoDatWhoDer
3 Replies
8. Shell Programming and Scripting
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Discussion started by: compprog11
4 Replies
9. Shell Programming and Scripting
Hello All,
I have a UNIX script which will prepare anonymous oracle pl/sql block in a temporary file in run time and passes this file to sqlplus as given below.
cat > $v_Input_File 2>>$v_Log << EOF
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DML PARALLEL 16';
EXECUTE... (1 Reply)
Discussion started by: vikas_trl
1 Replies
10. Shell Programming and Scripting
Hello All,
I have exactly same issue @vikas_trl had in following link:
https://www.unix.com/shell-programming-and-scripting/259854-control-not-returning-sqlplus-calling-unix-shell-script.html
I wonder if he or somebody else could find the issue's cause or the solution.
Any help would... (4 Replies)
Discussion started by: RicardoQ
4 Replies
LEARN ABOUT DEBIAN
www::search::washpost
WWW::Search::WashPost(3pm) User Contributed Perl Documentation WWW::Search::WashPost(3pm) NAME
WWW::Search::WashPost - WWW::Search backend for searching www.washingtonpost.com SYNOPSIS
use WWW::Search; my $oSearch = new WWW::Search('WashPost'); my $sQuery = WWW::Search::escape_query("japan prime minister"); $oSearch->native_query($sQuery); while (my $oResult = $oSearch->next_result()) { print $oResult->url, " "; } DESCRIPTION
This class is a specialization of WWW::Search. It handles making and interpreting searches on news at The Washington Post http://www.washingtonpost.com. This class exports no public interface; all interaction should be done through WWW::Search objects. NOTES
In the resulting WWW::SearchResult objects, the following elements will be set (in addition to the usual title, description, etc.): source Something like "Post" or a certain "Edition". location The page number of the print edition, e.g. "E05". category The type of item found, either "Article" or "Photo". seller The author or photographer. SEE ALSO
To make new backends, see WWW::Search. CAVEATS
This backend (and all its subclasses) only searches news stories from the last 14 days. (This is a restriction on the Washington Post website that we can not avoid.) BUGS
Please tell the author if you find any! AUTHOR
Martin Thurn <mthurn@cpan.org> LICENSE
Copyright (C) 1998-2009 Martin 'Kingpin' Thurn This software is released under the same license as Perl itself. perl v5.12.4 2011-11-02 WWW::Search::WashPost(3pm)