|
|
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 303001635 by RudiC on Tuesday 8th of August 2017 08:57:39 AM
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 NETBSD
esp
ESP(4) BSD Kernel Interfaces Manual ESP(4) NAME
esp -- NCR 53C9x, Emulex ESP406, and Qlogic FAS408 SCSI driver SYNOPSIS
ISA bus esp0 at isa? port 0x230 irq ? PCMCIA esp* at pcmcia? function ? MCA esp* at mca? slot ? mac68k esp0 at obio? esp1 at obio? macppc esp0 at obio0 flags 0x00ff sun3x esp0 at obio0 addr 0x66000000 ipl 2 flags 0xff0f sparc dma0 at obio0 addr 0xfa001000 level 4 (Sun 4/300) esp0 at obio0 addr 0xfa000000 level 4 (Sun 4/300) dma0 at sbus0 slot ? offset ? (sun4c and sun4m) esp0 at sbus0 slot ? offset ? (sun4c) esp0 at dma0 (sun4m) dma* at sbus? slot ? offset ? (Sbus) esp* at sbus? slot ? offset ? (SBus, older PROMs) esp* at dma? (SBus) scsibus* at esp? DESCRIPTION
The esp driver provides support for the NCR 53C90, 53C94 and 53C96; Emulex ESP100, ESP100A, ESP200 and ESP406; and Qlogic FAS216 and FAS408 SCSI controller chips found in a wide variety of systems and peripheral boards. This includes the Qlogic ISA and VLB SCSI host adapters, and the Sun Fast SCSI buffered Ethernet for Sbus (FSBE/S, X1053A, Sun part # 501-2015). For Qlogic PCI SCSI host adapters, use the isp(4) device. CONFIGURATION
The esp driver supports the following flags for use in config(1) files: bits 0-7: disable disconnect/reselect for the corresponding SCSI target bits 8-15: disable synchronous negotiation for the corresponding SCSI target bits 16-23: disable tagged queuing for the corresponding SCSI target "Target" is synonymous with SCSI ID number. Note that SCSI tape drives should be allowed to perform disconnect/reselect or performance will suffer. SEE ALSO
cd(4), ch(4), intro(4), le(4), mca(4), pcmcia(4), scsi(4), sd(4), ss(4), st(4), uk(4) http://www.qlc.com/ http://www.sun.com/ BSD
December 3, 2001 BSD