|
|
Sponsored Content
Homework and Emergencies
Homework & Coursework Questions
How to Dynamically Pass Parameter to plsql Function & Capture its Output Value in a Shell Variable?
Post 303001655 by Don Cragun on Tuesday 8th of August 2017 03:12:53 PM
08-08-2017
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Suppose I have a unix variable called RGNM which is holding a value. Now I want to call a plsql function in my script. THis plsql function takes one IN parameter. I want to pass my UNIX VARIABLE Value to the plsql function. Can i just give it by giving $RGNM in the function after calling sqlplus... (1 Reply)
Discussion started by: cobroraj
1 Replies
2. Shell Programming and Scripting
Hi there!
I'm trying to write a script that will capture output from a command and assign it to a variable.
Let's say, for example, I'd like to catch from inside the script whatever the following command outputs:
ls *.aaa
and put it into a variable "listoffiles".
What I tried was:
set... (3 Replies)
Discussion started by: machinogodzilla
3 Replies
3. Shell Programming and Scripting
HI all
I have a code like
##############################################
minyear()
{
curryear=$1
echo $curryear
}
##Main Program ##
minyear
exit
#######
when i execute "sh scriptname 2005" output should be like 2005 but the output is blank.
I guess i need to pass parameter to... (3 Replies)
Discussion started by: vasuarjula
3 Replies
4. Shell Programming and Scripting
I need to pass a variable as a parameter from shell script into a DB2 database.
var=bhuk_1123_Q_11/22/09
select * from tbl1 where serial_id='$var';
I have tried executing it using
db2 -tvf scriptname
Somebody please help me out with this. It is throwing an error. Please tell me how... (2 Replies)
Discussion started by: ss3944
2 Replies
5. Shell Programming and Scripting
what is the maximum number of parameter we can pass to a shell script function (8 Replies)
Discussion started by: alokjyotibal
8 Replies
6. Shell Programming and Scripting
Hello,
Can anyone guide me tin passing parameters into user defined function of shell script (KSH).
Here is my code,
InsertRecord()
{
DB_TBL=$(sqlplus $USERID/$PASSWORD@$DATABASE << EOF
set head off
set feed off
set serveroutput on
INSERT INTO TBL1 ( OLD_VAL,
NEW_VAL,
... (7 Replies)
Discussion started by: Poonamol
7 Replies
7. Shell Programming and Scripting
Hello again :)
Am currently trying to write a function which will delete a record from a file.
The code currently looks as such:
function deleteRecord() {
clear
read -p "Please enter the ID of the record you wish to remove: " strID
... (2 Replies)
Discussion started by: U_C_Dispatj
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
How to capture system() function output in awk variable and the print that awk variable..... (8 Replies)
Discussion started by: bharat1211
8 Replies
10. Shell Programming and Scripting
Hi Gurus,
I have request which needs to pass position parameter to a function. I tried below simple code, it doesn't work.
#!/bin/bash
func_1(){
echo $1
}
func_1
$ ./set_file abc
$
do I need add some to get the position para first?
thanks in advance. (3 Replies)
Discussion started by: ken6503
3 Replies
LEARN ABOUT FREEBSD
esp
ESP(4) BSD Kernel Interfaces Manual ESP(4) NAME
esp -- Emulex ESP, NCR 53C9x and QLogic FAS families based SCSI controllers SYNOPSIS
To compile this driver into the kernel, place the following lines in your kernel configuration file: device scbus device esp Alternatively, to load the driver as a module at boot time, place the following line in loader.conf(5): if_esp_load="YES" DESCRIPTION
The esp driver provides support for the AMD Am53C974, the Emulex ESP100, ESP100A, ESP200 and ESP406, the NCR 53C90, 53C94 and 53C96 as well as the QLogic FAS100A, FAS216, FAS366 and FAS408 SCSI controller chips found in a wide variety of systems and peripheral boards. HARDWARE
Controllers supported by the esp driver include: o MELCO IFC-DP (PC-98) o Sun ESP family o Sun FAS family o Tekram DC390 o Tekram DC390T SEE ALSO
cd(4), ch(4), da(4), intro(4), pci(4), sa(4), sbus(4), scsi(4), camcontrol(8) HISTORY
The esp driver first appeared in NetBSD 1.3. The first FreeBSD version to include it was FreeBSD 5.3. AUTHORS
The esp driver was ported to FreeBSD by Scott Long <scottl@FreeBSD.org> and later on considerably improved by Marius Strobl <marius@FreeBSD.org>. BUGS
The esp driver should read the EEPROM settings of Tekram controllers. BSD
November 1, 2011 BSD