Need Help: Shell script to call sql session with variables stored in .txt file
Hi,
I need help in writing a shell script which can read data from a text file (Cancel_ID.txt) and then calls sqlplus session (Cancel.sql) with the first line parameter of the text file ("0322600453") till all rows are not completed.
The data in text file will be like following:
0322600453
CAN
5076
2867000260
CAN
3496
Code:
sqlplus -S <<EOF > /dev/null
user/password@universe
WHENEVER OSERROR EXIT 9;
WHENEVER SQLERROR EXIT SQL.SQLCODE;
SET ECHO ON
SET SERVEROUTPUT ON
SPOOL $LOGFILE
-------------------------------------------------------------------------------------
---- Here I need to make a loop to read text file and pass on the first line as
---- parameter to following .sql script till all the rows are not finished in text
---- file
-------------------------------------------------------------------------------------
@cancel.sql
SPOOL OFF
EOF
sql_return_code=$?
if [ $sql_return_code != 0 ]
then
echo "The Cancel.sql script failed. Please refer to the log results.txt for more information"
echo "Error code $sql_return_code"
exit 0;
fi
I like to call a shell script from pl/sql proceduere and i have to use the shell script return value in that procedure. i am using oracle 9i and cygwin.
can any one suggest me how can i do this (0 Replies)
I would like to call the shell script from pl/sql and i need to uses the value returned by the shell script in pl/sql procedure.
can any one suggest me how can i do that? (3 Replies)
Hello,
I am doing a shell script which contain a pl/sql loop to search for 3 values, i would like to call another shell script inside this sql loop each time it find the values. so how can i call shell script from pl/sql using its variables, any idea?
Here is idea about the code:
my... (1 Reply)
Hi Experts,
I want to call script_name.ksh as many time as id in customer table and also pass it as a parameter to script.
someting Like below.
for i in select id from customer
do
./script_name.ksh $i &
done
I have figured out how to have ID from customer but now how to call... (3 Replies)
I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable? (0 Replies)
Hi i am not able to connect sqlplus
my script is as follows
$ORACLE_HOME/bin/sqlplus << ! > /tmp/extract/DM.txt
and output is
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Jan 18 02:53:54 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter user-name: t175481... (1 Reply)
Hi Guys,
I need to write a simple shell script which will generate a .csv file/report by calling .sql file inside a shell script.
Can somebody help me on this.
Thanks in advance!
Regards,
LK (7 Replies)
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Hi, I am complete new to C programming and shell scripting. I just wrote a simple C code to calculate integral using trapezoid rule. I am prompting user to pass me No. of equally spaced points , N , upper and lower limit. My code looks as follows so far:
#include<stdio.h>
#include<string.h>... (2 Replies)
hi ,
the below script contains sql query and after executed it sends the output of the query (output.txt) to an email body with conditional subject line based on the output of all_counts_match.txt.
i want to make this script generic so that it can accept the sql file as parameter and can... (5 Replies)
Discussion started by: itzkashi
5 Replies
LEARN ABOUT DEBIAN
trcs
trcs(1) User Manuals trcs(1)NAME
trcs - convert text files from one codeset to other
SYNOPSIS
trcs -C | -l | -h
trcs [-s] [-f input-codeset ] [-t output-codeset ] [ file ]...
DESCRIPTION
trcs is a program for translation of text files from one codeset to other. When exact translation is impossible it tries to make approxi-
mations. For example pseudographic characters are approximated by ASCII characters in codesets that have no pseudographic characters and
characters with diacritical marks are approximated by existing characters.
If the option -s or --gen-script is given trcs will generate simple script that invokes tr(1) This is useful if you want to include this in
your script or for faster conversion of many files.
If none of -C, -s, -l, -h and their equivalents is given each file will be read assuming it is coded with codeset input-codeset On standard
output it will be recoded so to use codeset output-codeset If there is no file given trcs will act as filter. Both input-codeset and out-
put-codeset are case insensitive and default to `cp1251'.
OPTIONS -C, --copyright
Display copying conditions and warranty information.
-s, --gen-script
Generates conversion script for given input and output encodings instead to convert text files.
-l, --list
List all known codesets with their aliases.
-h, --help
Display this help and exit.
-f input-codeset, --from[=]input-codeset
Codeset of the source.
-f output-codeset, --to[=]output-codeset
Codeset of the output.
EXAMPLES
trcs -fcyrillic -t koi8-r letter.txt
Convert letter.txt from ISO-8859-5 (cyrillic) to KOI8-R and output the result on standard output.
trcs --from cp437 --to=mik --gen-script >ibm2mik
Generates script ibm2mik for converting from CP437 to MIK.
sh ibm2mik screen.txt
Convert screen.txt from CP437 to MIK. Output the result on standard output. Without parameters ibm2mik acts as filter.
AUTHOR
Anton Zinoviev <anton@lml.bas.bg>, <zinoviev@fmi.uni-sofia.bg>
SEE ALSO tr(1)Linux JUN 2000 trcs(1)