Execute an Oracle stored procedure from a shell scrip Post: 73739

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. Shell Programming and Scripting

How to execute an Oracle procedure using shell

Hi , i have created an .sh file that has the following code: #!/bin/ksh sqlplus -s p1istuat/p1istuat@CWS_IST6 @Procedure_Execute.sql & sqlplus -s p1istuat/p1istuat@CWS_IST6 << EOF exit EOF The mentioned Procedure_Execute.sql file inside has the following code: exec TEST; ...

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...

5. 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. Shell Programming and Scripting

how to call oracle stored procedure from unix shell

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;...

7. Shell Programming and Scripting

How to execute the stored procedure from shell script

How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file.

8. Shell Programming and Scripting

Execute a shell script from Oracle procedure

Hi Gurus, Want to execute a shell script from a oracle procedure and get the status of the same, any assistance in this regard will be appreciated. proc_data.sh is script name which I want to execute from oracle procedure It should work something like below procedure test begin...

9. Shell Programming and Scripting

Unable to execute Stored Procedure from CRON

Hi, I am very new to this environment - I hope this is the right platform to discuss my issue: I created a CRON job to run a Stored Procedure from our database - Sybase. Within the Stored Procedure there is a TRUNCATE table and CREATE table function. the CRON job fails to run with...

10. UNIX for Beginners Questions & Answers

Shell script to execute Oracle procedure and trigerring email on success and failure

Here is the shell script which need to trigger a stored procedure and when the record count is 0 then it should capture in the log that 0 duplicate records are found and if it's more than 0 then log with no of records. Also if there is any sqlerror then it should write the same in the log file and...

LEARN ABOUT LINUX

logsave

LOGSAVE(8)						      System Manager's Manual							LOGSAVE(8)

NAME

       logsave - save the output of a command in a logfile

SYNOPSIS

       logsave [ -asv ] logfile cmd_prog [ ... ]

DESCRIPTION

       The  logsave  program  will  execute  cmd_prog with the specified argument(s), and save a copy of its output to logfile.  If the containing
       directory for logfile does not exist, logsave will accumulate the output in memory until it can be written out.	A copy of the output  will
       also be written to standard output.

       If  cmd_prog  is a single hyphen ('-'), then instead of executing a program, logsave will take its input from standard input and save it in
       logfile

       logsave is useful for saving the output of initial boot scripts until the /var partition is mounted,  so  the  output  can  be  written	to
       /var/log.

OPTIONS

       -a     This option will cause the output to be appended to logfile, instead of replacing its current contents.

       -s     This  option  will  cause  logsave  to  skip writing to the log file text which is bracketed with a control-A (ASCII 001 or Start of
	      Header) and control-B (ASCII 002 or Start of Text).  This allows progress bar information to be visible to the user on the  console,
	      while not being written to the log file.

       -v     This option will make logsave to be more verbose in its output to the user.

AUTHOR

       Theodore Ts'o (tytso@mit.edu)

SEE ALSO

       fsck(8)

E2fsprogs version 1.41.14					   December 2010							LOGSAVE(8)