|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Oracle function invoked from shell script doubt
Post 302950541 by jim mcnamara on Sunday 26th of July 2015 11:39:29 AM
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
....does the dbms_output.put_line work inside unix shell script?
i mean this is to be inside the sqlplus connection as follows!!
sqlplus -s $UP <<EOJ
..
..
..
dbms_output.put_line ('Insertion procedure failed for UPC BC : ' || wk_key_value || ' Sqlcode: ' || SQLCODE || ' Error... (2 Replies)
Discussion started by: mexx_freedom
2 Replies
2. Shell Programming and Scripting
Hi all,
I am trying to run a script in crontab but I receive the email below. Note the empty variable SHELL. Apparently cron doesn't invoke a shell. That explains the errors in the script it is trying to execute. Anyone know what maybe wrong?
Subject: Output from cron job... (3 Replies)
Discussion started by: ivanushka
3 Replies
3. Shell Programming and Scripting
i want to call a oracle function in my shell script (4 Replies)
Discussion started by: dineshr85
4 Replies
4. Shell Programming and Scripting
Hi,
While reading a shell script ,i have come accross the following statements.
script_name_full=$0
***script_name=${script_name_full##*\}
***script_name_noexst=${script_name%%\.ksh}
host_name=`hostname`
***host_name_short=${host_name%%\.*}
can anybody tell me what is the purpose of marked... (5 Replies)
Discussion started by: ravi raj kumar
5 Replies
5. Shell Programming and Scripting
Hi,
I'm a newbie in shell script.
I have a problem in running my a.out in a bash shell script named vetri . The following is the code.
#!bash/bin
./a.out abc.xyz
where ./a.out is a c++ bin file and abc.xyz is an argument. My ./a.out expects an input (cin >> temp). How can I give the... (5 Replies)
Discussion started by: lchokka
5 Replies
6. Shell Programming and Scripting
hi,
I am new script learner,
so my basic doubt is ,
how to store value of any command in a variable example
$ ls | wc -l
i want to stote the output of this in a variable c.
so that i can use c in if else loop.
and when do we use " ` " symbol in script..
can anyone also tell for... (5 Replies)
Discussion started by: hi2_t
5 Replies
7. Shell Programming and Scripting
This is my function which is creating three variables based on counter & writing these variable to database by calling another function writeRecord
but only one record is getting wrote in DB.... Please advise ASAP...:confused:
function InsertFtg
{
FTGSTR=""
echo "Saurabh is GREAT $#"
let... (2 Replies)
Discussion started by: omkar.sonawane
2 Replies
8. Shell Programming and Scripting
Hello,
I am trying to execute an SQL query from shell script.
A part of script is something like this:
fromDate=`echo $(date +"%F%T") | sed "s/-//g" | sed "s/://g"`
$ORACLE_HOME/sqlplus -s /nolog <<EOD1
connect $COSDBUID/$COSDBPWD@$COSDBSID
spool... (4 Replies)
Discussion started by: sanketpatel.86
4 Replies
9. Shell Programming and Scripting
Dear All,
I want to know how can i call oracle function from shell script code . My oracle function have around 5 input parameters and one return value.
for name in *.csv;
do
echo "connecting to DB and start processing '$name' file at "
echo "csv file name=$x"
sqlplus -s scoot/tiger <!... (2 Replies)
Discussion started by: Balraj
2 Replies
10. Shell Programming and Scripting
Hi
I need to call a function in database and update the return value of that function with a value in csv file.
test.csv
1,2,3,,5,,,8,9,10
1,2,3,4,5,,,8,9,10
1,2,3,,,,,8,9,10In the above file I want to replace column 2 with a value extracted from database
like (select student_id from... (3 Replies)
Discussion started by: kev94
3 Replies
LEARN ABOUT DEBIAN
shisa_cfg_db
shisa_cfg_db(3) shishi shisa_cfg_db(3) NAME
shisa_cfg_db - API function SYNOPSIS
#include <shisa.h> int shisa_cfg_db(Shisa * dbh, const char * value); ARGUMENTS
Shisa * dbh Shisa library handle created by shisa(). const char * value string with database definition. DESCRIPTION
Setup and open a new database. The syntax of the value parameter is "TYPE[ LOCATION[ PARAMETER]]", where TYPE is one of the supported database types (e.g., "file") and LOCATION and PARAMETER are optional strings passed to the database during initialization. Neither TYPE nor LOCATION can contain " " (SPC), but PARAMETER may. RETURN VALUE
Returns SHISA_OK if database was parsed and open successfully. REPORTING BUGS
Report bugs to <bug-shishi@gnu.org>. COPYRIGHT
Copyright (C) 2002-2010 Simon Josefsson. Copying and distribution of this file, with or without modification, are permitted in any medium without royalty provided the copyright notice and this notice are preserved. SEE ALSO
The full documentation for shishi is maintained as a Texinfo manual. If the info and shishi programs are properly installed at your site, the command info shishi should give you access to the complete manual. shishi 1.0.1 shisa_cfg_db(3)