|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Execute a shell script from Oracle procedure
Post 302524924 by cero on Wednesday 25th of May 2011 05:26:20 AM
05-25-2011
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
hi,
this is urgent..can i run a shell script from store procedure without using java. (8 Replies)
Discussion started by: arnabb4u
8 Replies
3. Shell Programming and Scripting
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
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;
... (5 Replies)
Discussion started by: vins_san
5 Replies
5. Shell Programming and Scripting
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
6. 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
7. Shell Programming and Scripting
How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file. (2 Replies)
Discussion started by: dineshmurs
2 Replies
8. Shell Programming and Scripting
i have the following code inside a shell script .prog in oracle server when i call the program
DBMS_OUTPUT.PUT_LINE(x_return_status|| ln_rep_req_id);
will return 0 , it is very strange , i try to submit the concurrent request in oracle , and it can successfully executed, what am i missing ? i... (1 Reply)
Discussion started by: feilhk
1 Replies
9. Shell Programming and Scripting
Hi ,
I am trying to automate a gather stats in shell script
#!/usr/bin/ksh
export ORACLE_HOME=/orcl/app/oracle/product/11.2.0.1/db_1
export PATH="$PATH:$ORACLE_HOME/bin"
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$ORACLE_HOME/lib32"
export TNS_ADMIN=/opt/netprobe/config... (1 Reply)
Discussion started by: neil.k
1 Replies
10. UNIX for Beginners Questions & Answers
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... (17 Replies)
Discussion started by: senmng
17 Replies
LEARN ABOUT DEBIAN
firefox
FIREFOX(1) Linux User's Manual FIREFOX(1) NAME
firefox - a Web browser for X11 derived from the Mozilla browser SYNOPSIS
firefox [OPTIONS] [URL] DESCRIPTION
Mozilla Firefox is an open-source web browser, designed for standards compliance, performance and portability. USAGE
firefox is a simple shell script that will set up the environment for the actual executable. OPTIONS
A summary of the options supported by firefox is included below. GTK options --gdk-debug=FLAGS Gdk debugging flags to set --gdk-no-debug=FLAGS Gdk debugging flags to unset --gtk-debug=FLAGS Gtk+ debugging flags to set --gtk-no-debug=FLAGS Gtk+ debugging flags to unset --gtk-module=MODULE Load an additional Gtk module X11 options --display=DISPLAY X display to use --sync Make X calls synchronous --no-xshm Don't use X shared memory extension --xim-preedit=STYLE --xim-status=STYLE --g-fatal-warnings Make all warnings fatal Firefox options -h, -help Show summary of options. -height value Set height of startup window to value. -width value Set width of startup window to value. -v, -version Print /usr/bin/firefox-bin version. -CreateProfile profile Create profile. -P profile Start with profile. -ProfileManager Start with profile manager. -UILocale lang-region Start with lang-region resources. -contentLocale lang-region Start with lang-region resources. -remote command Execute command in an already running Firefox process. For more info, see: http://www.mozilla.org/unix/remote.html -no-remote Don't try to control an already running instance. -jsconsole Start with Javascript Console -chrome url Load the specified chrome. -new-window url Open URL in a new window if Firefox is already running. -new-tab url Open URL in a new tab if Firefox is already running. -preferences Open Firefox preferences menu. -safe-mode Disables extensions and themes for this session. FILES /usr/bin/firefox - shell script wrapping firefox /usr/lib/firefox/firefox - firefox executable VERSION
3.0 BUGS
To report a bug, please visit http://bugzilla.mozilla.org/ SEE ALSO
mozilla(1) AUTHORS
The Mozilla Organization http://www.mozilla.org/about.html firefox January 04, 2006 FIREFOX(1)