10-29-2009
calling two procedures from one ksh ???
Hi to all,
This is first posting in this forum. I quite new to this KSH....i guess i ll have some fun...
Well, I have two indivdual korn shell scripts. i m calling PL/SQL stored procedure from korn shell script. It works absolutely fine. Once its completed the log is updated and data is loaded into tables. These two loades the data into two different tables. Then have dependency.
So i have to run A.ksh and Later B.ksh. If i run B.ksh first then data will not be loaded since it has dependency on A.ksh.
So i was trying to merge into one korn shell script. First run 1st procedurer if successfully completed then run 2nd procedure. if 1st procedure is failed then dont run 2nd procedure.
So how do i accomplish this in korn shell script ??? Any idea guys
Thank you so much in advance !!!
10 More Discussions You Might Find Interesting
1. Solaris
I have created 3 Procedures all similar to this one:
I then created 3 shell sripts which will call the sql? finally created a calling script to call the procedure. I am a bit unsure how to this all works, can someone check my code and I am doing this right? Also could I add my procedure (first... (0 Replies)
Discussion started by: etravels
0 Replies
2. Shell Programming and Scripting
Hi
I have a stored procedure which should be called from KSH.
Could ayone please help me with this.
Thanks (1 Reply)
Discussion started by: BlAhEr
1 Replies
3. Shell Programming and Scripting
Hi ,
I have a shell script which does some calling of procedures
once all the procedures are called I need to start another
ksh script which is present on a different unix box
How can this be done ?
Do I need to open a telnet session to connect to that box in my first script and... (1 Reply)
Discussion started by: Navatha
1 Replies
4. Shell Programming and Scripting
hi, I have a csh script, which has
setenv X xyz etc
My shell is korn
Is there some way I can "source" this to have the variables in my current korn shell?
thanks (3 Replies)
Discussion started by: JamesByars
3 Replies
5. Shell Programming and Scripting
All:
I am calling a PERL script from KSH. I need specific codes to be returned by the PERL Script.
For ex:
Ksh
-----
result=`test.pl $FILE`
My idea is to get the value of result from the test.pl, by specifically making the test.pl to print the return code. Since I had some other print... (1 Reply)
Discussion started by: ucbus
1 Replies
6. Shell Programming and Scripting
Hi,
I have a below command in ksh ....
$JAVA_HOME/bin/java -cp "/usr/orabase/product/10.2.0/lib:/usr/java/javajar/common/sched.jar:/usr/orabase/product/10.2.0/jdbc/lib/ojdbc14_g.jar:/usr/orabase/product/10.2.0/jdbc/lib/classes12.jar" com.abrt.smart.Smart
I want to know where the... (1 Reply)
Discussion started by: PRKS
1 Replies
7. Shell Programming and Scripting
I have a script with 2 functions
1) show_menu
2) create
Ths show_menu function works fine....... Sort of....
When I select option 2 of the menu the code does a few commands and then calls another function called create. It's at this point that I get "create: not found".....
However,... (2 Replies)
Discussion started by: hxman
2 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I am not able to run below command on linux, it however works on solaris. If anyone knows the reason and a solution for it can you please let me know ?
Linux
-----
$> ksh 'echo hi'
ksh: echo hi: No such file or directory
$> which ksh
/usr/bin/ksh
Solaris
------
$> ksh 'echo... (2 Replies)
Discussion started by: krishnaux
2 Replies
9. Shell Programming and Scripting
Friends,
I'm newbie with ksh so wanting some help....
1. I'm trying to call oracle stored procedure from ksh script by taking variable value from runtime, feed into script and execute procedure.
2. Put name1 and name2 value from script run replacing $3 & $4
I'm trying to put name1 in... (4 Replies)
Discussion started by: homer4all
4 Replies
10. UNIX for Beginners Questions & Answers
I ran into an issue today that I was able to resolve, but I don't quite understand why the resolution worked. I'm wondering if anyone can help me make sense of it.
I have a "kicker" script that calls 4 subscripts on a RHEL 6.9 server. It calls the scripts in sequence checking for a 0 exit code... (5 Replies)
Discussion started by: derndingle
5 Replies