Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: how to call oracle stored procedure from unix shell
Top Forums Shell Programming and Scripting how to call oracle stored procedure from unix shell Post 302398911 by Nila on Thursday 25th of February 2010 11:40:45 PM
Old 02-26-2010
Try this,


Code:
#!/bin/sh
sqlplus -s username/password<<END
execute procedure_name( parameters,....)
Commit;
exit;
END


eg:

sqlplus -s scott@dbase/tiger<<END
execute test_proc(nila,20,101);
commit;
exit;
END


after this save and exit from editor
and run in from the uix prompt... sh sciptname

it will work..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Execute an Oracle stored procedure from a shell scrip

Here is a snippet of my code: if then echo "\n Deleting all reports older than 24 hours. \n" >> $logfile ls -l $FileName >> $logfile ... (1 Reply)
Discussion started by: mh53j_fe
1 Replies

2. Shell Programming and Scripting

Shell arrays in oracle stored procedure

Is it possible to pass unix shell arrays in Oracle stored procedure? Is yes, how? Thanks (6 Replies)
Discussion started by: superprogrammer
6 Replies

3. Shell Programming and Scripting

Calling an Oracle Stored Procedure from Unix shell script

hai, can anybody say how to call or to execute an oracle stored procedure in oracle from unix... thanks in advance.... for ur reply.... by, leo (2 Replies)
Discussion started by: Leojhose
2 Replies

4. Shell Programming and Scripting

Invoking Oracle stored procedure in unix shell script

Here's a shell script snippet..... cd $ORACLE_HOME/bin Retval=`sqlplus -s <<eof $TPDB_USER/april@$TPD_DBCONN whenever SQLERROR exit 2 rollback whenever OSERROR exit 3 rollback set serveroutput on set pages 999 var status_desc char(200) var status_code... (1 Reply)
Discussion started by: hidnana
1 Replies

5. Shell Programming and Scripting

Need to call stored procedure from unix script

Hi Guys, I have a stored procedure which has 5 out parameters. I need to call the stored procedure from the script. When i use the following in my script, db2 "CALL FCFM.PART_MASTER_TMP($Return_code,$Message,$Message1,$SQL,$Load_count)" >> $LOG_FILE I am getting an error.. Please... (1 Reply)
Discussion started by: mac4rfree
1 Replies

6. Shell Programming and Scripting

how to pass the values to unix shell from the oracle stored procedure.

Hi i am calling a stored procedure from unix shell like this call test_proc('0002','20100218'); the stored procedure was giving output like this dbms_output.put_line(' processed earlier'); i want to see the output in the unix shell where i called. Thanks barani (6 Replies)
Discussion started by: barani75
6 Replies

7. Shell Programming and Scripting

Call and redirect output of Oracle stored procedure from unix script

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

8. Shell Programming and Scripting

How to call a stored procedure from shell program?

How to call a stored procedure from shell program (1 Reply)
Discussion started by: noorm
1 Replies

9. Shell Programming and Scripting

How to call stored procedure with CLOB out parameter from shell script?

I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable? (0 Replies)
Discussion started by: vel4ever
0 Replies

10. Shell Programming and Scripting

Need to run Oracle stored procedure from UNIX env

Hi Everyone, I want to create a script where i need to run the oracle stored procedure from unix script and get the output(sequence number ) into a variable which i will pass in my datastage job. Below is my stored procedure:- DECLARE P_TRANSTYPE VARCHAR2(20); ... (4 Replies)
Discussion started by: prasson_ibm
4 Replies

LEARN ABOUT DEBIAN

lsh-pam-checkpw

LSH-PAM-CHECKPW(8)						    lsh manuals 						LSH-PAM-CHECKPW(8)

NAME

       lsh-pam-checkpw - program to check a PAM username/password combination

SYNOPSIS

       lsh-pam-checkpw username-to-check

DESCRIPTION

       This manual page documents briefly the lsh-pam-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-pam-checkpw is a program that checks if a username and password combination is valid for login by doing a PAM lookup. It is designed to
       be used as a password helper program for lshd (8), (eg.	--password-helper=/usr/sbin/lsh-pam-checkpw.

       lsh-pam-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-pam-checkpw 						    Jul 05 2002 						LSH-PAM-CHECKPW(8)
All times are GMT -4. The time now is 08:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy