Hi my UNIX Friends,
Im calling some SQL scripts through Unix Shell scripting.
How do I export the value of PL/SQL variable value into a Unix shell script variable?
Also could any one inform me about the 'search' and 'cut' utility of PL/SQL
(like 'grep' and 'cut' in Shell scripting).
... (10 Replies)
Hi Folks,
This is a small chunk of the bigger problem which i am facing and some help here will help me resolve the rest of the issue.
Problem is that i need to pass the value of a variable from a shell script to a SQL query (infact a lot of SQL's)
i have the following solution but somehow... (4 Replies)
I have this piece code in a shl, I need to pass paramaters to a PL\SQL
PRECEDURE like $fseqno and faidy I know that the $fseqno works correctly but I am not sure aboyt the faidy
can I code it like that faidy ='0910' ?
Thank you
for i in 3526*.dat
do
# Capture just the file... (1 Reply)
Hi Gurus,
i have one requirement in unix script, i have a file called abc.txt in that few lines are there with the empid, i need to read each line and pass to .sql script.
ex:
abc.txt
2345
2346
1243
1234
i need to pass these arguments to .sql script rom unix
ex:
select * from... (1 Reply)
Hi Everyone,
Can anyone help me how do i call hash variable in to sql query in perl. Please see the script below
i have defined two Hash %lc and %tab as below
$lc{'REFF'}='V_RES_CLASS';
$lc{'CALE'}='V_CAP_CLASS';
$lc{'XRPD'}='V_XFMR_CLASS';
$tab{'V_RES_CLASS'}='V_MFR_SERS';... (6 Replies)
Hi Guys,
I am trying to pass a string variable from Unix shell script to sqlplus as a parameter.
I have tried using single quotes with the variable name but it does not work. Please help me with it.
I am using BASH.
My code:
Your help is much appreciated.
Thanks,
shil (2 Replies)
Hi Friend,
I have one file in which some number are mentioned and number of lines are vary every time
And i need to pass that number to my sql command from script.
Suppose i have file acc.txt
45456546456
45464564565
67854353454
67657612132
Number of records are vary every time.... (20 Replies)
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Hi all,
I have a a file which contains an oracle query. If this file is pushed into a shell script such as the below, it of course works fine.
#!/usr/bin/sh
su - oracle -c 'sqlplus -s / as sysdba <<EOF
@/home/cron/ORA/sql/T-ORA006-OracleSessions.sql
exit;
EOF
.
What i am after... (2 Replies)
Discussion started by: nms
2 Replies
LEARN ABOUT DEBIAN
tentacle_client
TENTACLE_CLIENT(1) Client file transfer protocol TENTACLE_CLIENT(1)NAME
tentacle_client - a client file transfer protocol
SYNOPSIS
tentacle_client <options> Tentacle is a client/server file transfer protocol that aims to be:
- Executable programs or shell commands
- System calls (functions provided by the kernel)
- Library calls (functions within program libraries)
Tentacle was created to replace more complex tools like SCP and FTP for simple file transfer/retrieval, and switch from authentication
mechanisms like .netrc, interactive logins and SSH keys to X.509 certificates. Simple password authentication over a SSL secured connection
is supported too.
The client and server (TCP port 41121) are designed to be run from the command line or called from a shell script, and no configuration
files are needed.
Tentacle is now the default file transfer method for Pandora FMS and Babel Enterprise.
Tentacle is implemented in Perl and ANSI C (Windows platforms included).
You can download it and get more information at the official Sourceforge website http://tentacled.sourceforge.net/.
OPTIONS
Tentacle Client options :
-a address : Server address (default 127.0.0.1).
-c : Enable SSL without a client certificate.
-e cert : OpenSSL certificate file. Enables SSL.
-f ca : Verify that the peer certificate is signed by a ca.
-g : Get files from the server.
-h : Show help.
-k key : OpenSSL private key file.
-p port : Server port (default 41121).
-q : Quiet. Do now print error messages.
-r number : Number of retries for network operations (default 3).
-t time : Time-out for network operations in seconds (default 1s).
-v : Be verbose.
-w : Prompt for OpenSSL private key password.
-x pwd : Server password.
EXAMPLES
tentacle_client -a 192.168.1.1 -v /bin/bash
Simple file transfer with maximum file size set to 1MB
tentacle_client -a 192.168.1.1 -x password -v /bin/bash
Simple file transfer with password authentication (not secure)
tentacle_client -a 192.168.1.1 -x password -e cert.pem -k key.pem -v /bin/bash
Secure file transfer with client certificate and password authentication
NOTES
Tentacle requires Perl 5.8 or higher to works
SEE ALSO tentacle_server(1), pandora_server(1), pandora_agent(1)0.2.0 2010-05-11 TENTACLE_CLIENT(1)