|
|
Sponsored Content
Operating Systems
Linux
Red Hat
How to call Oracle package through shell script?
Post 302804673 by vidyadhar85 on Thursday 9th of May 2013 04:35:02 AM
05-09-2013
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
OS: Solaris
Is it possible to make a package out of a shell script. Creating a package out of an executable is heard of but what about a shell script
?? (1 Reply)
Discussion started by: run_time_error
1 Replies
2. Shell Programming and Scripting
i want to call a oracle function in my shell script (4 Replies)
Discussion started by: dineshr85
4 Replies
3. Shell Programming and Scripting
Hi everyone!
I'm new with Shell Scripting, and I have to do a shell script to call a procedure, which have 2 input parameters, the directory(from server) and the txt file (which have informations to update/insert in DB).
I have to create a shell script to execute that procedure for each txt... (5 Replies)
Discussion started by: renatoal
5 Replies
4. Shell Programming and Scripting
Hi
i want to call a oracle stored procedure from unix (using bash shell).
consider this is my oracle stored procedure with parameter
create procedure testproc(name IN varchar, age IN Number, id OUT Number )
AS
begin
id=1;
dbms_output.put.line('successfull validation')
end;... (6 Replies)
Discussion started by: barani75
6 Replies
5. Shell Programming and Scripting
I have searched the forums and couldn't find my specific issue so I figure that I would post on it.
I am trying to run a simple sql script that spools to a flat file from a unix script.
I have tried to make the call outright from inside of the ksh script as such:
sqlplus... (3 Replies)
Discussion started by: BkontheShell718
3 Replies
6. Shell Programming and Scripting
Hi,
Can you assist me in how to redirect the output of oracle stored procedure from unix script?
Something similar to what i did for sybase
isql -U$MYDBLOG -D$MYDBNAME -S$MYDBSVR -P$MYDBPWD -o$MYFILE<< %%
proc_my_test 8
go
%%
Thanks in advance - jak (0 Replies)
Discussion started by: jakSun8
0 Replies
7. Shell Programming and Scripting
Hi,
Can anyone tell me how to call a oracle package from a Unix shell script? I want to pass some input parameters to package and it will return me the output which I want to use further in my shell script. I want to know the way to capture the output values in my shell script. Please send some... (1 Reply)
Discussion started by: anil029
1 Replies
8. Shell Programming and Scripting
Hello All,
I need immediate help in creating shell script to call archivebkup.ksh script when archive file system capacity reaches threshold value or 60%
Need to identify the unique file system that reaches threshold value.
ex:
capacity
... (4 Replies)
Discussion started by: sasikanthdba
4 Replies
9. Shell Programming and Scripting
How to call oracle package in shell file
in my shell file, I have
Export SQL FILE =$Home_dir select.sql
if I want to add call two function in package
how can I do it :( (2 Replies)
Discussion started by: Hscript
2 Replies
10. 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
LEARN ABOUT DEBIAN
lsh-krb-checkpw
LSH-KRB-CHECKPW(8) lsh manuals LSH-KRB-CHECKPW(8) NAME
lsh-krb-checkpw - program to check a Kerberos username/password combination SYNOPSIS
lsh-krb-checkpw username-to-check DESCRIPTION
This manual page documents briefly the lsh-krb-checkpw command. This manual page was written for the Debian distribution because the orig- inal program does not have a manual page. Instead, it has documentation in the GNU Info format; see below. lsh-krb-checkpw is a program that checks if a username and password combination is valid for login by doing a kerberos lookup. It is designed to be used as a password helper program for lshd (8), (eg. --password-helper=/usr/sbin/lsh-krb-checkpw. lsh-krb-checkpw takes one required argument, which is the username, and reads the password from stdin, then returns 0 if the password is valid, or 1 otherwise. Note that the password must be supplied exactly, ie. there must be no newline after the password, so if invoking from a shell, just type "<your-password><CTRL-D>". SEE ALSO
lsh(1), lshd(8). The programs are documented fully by Lsh, available via the Info system. AUTHOR
This manual page was written by Timshel Knoll <timshel@debian.org>, for the Debian GNU/Linux system (but may be used by others). lsh-krb-checkpw Nov 15 2005 LSH-KRB-CHECKPW(8)