10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a requirement of bash shell script calling SQL*Plus script.
sqlplus <user>/<pwd> @sqlscript1 parameters
sqlplus <user>/<pwd> @sqlscript2 parameters
Now I need the values generated by sqlscript1 in sqlscript2. But it is more like a huge dataset in a table and not one... (7 Replies)
Discussion started by: uuuunnnn
2. 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
3. Red Hat
Hey i have a package in oracle to validate file mask. can i call it in through
shell script . if yes , how
Thanks (1 Reply)
Discussion started by: ramsavi
4. Shell Programming and Scripting
I wanted to know the exact behavior of the shell scripts in the below scenario.
I have 2 scripts - a.ksh and b.ksh
Both these scripts call a 3rd script xyz.ksh.
What will happen if both a.ksh and b.ksh run at the same time?
What will happen if a.ksh starts 2-3 seconds before b.ksh?... (3 Replies)
Discussion started by: aster007
5. Shell Programming and Scripting
I have three korn shell script 3.1, 3.2, 3.3. I would like to call three shell script in one shell script.
i m looking for something like this
If 3.1 = "complete" then
if 3.2 = ''COMPlete" then
The... (1 Reply)
Discussion started by: shashi369
I am getting some errors when i am running the shell script using the following syntax:
but the same script works fine with the following syntax:
wats the difference in both....please help
thanks in advance. (6 Replies)
Discussion started by: arpit_narula
7. Shell Programming and Scripting
can anybody say how to call or to execute an oracle stored procedure in oracle from unix...
thanks in advance.... for ur reply....
leo (2 Replies)
Discussion started by: Leojhose
8. Shell Programming and Scripting
Oracle and Scripting gurus,
I need some help with this script...
I am trying to add the query
SELECT * FROM
WHERE SYNONYM_NAME = 'METADATA'
in the current script....
Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg.... (18 Replies)
Discussion started by: madhunk
9. UNIX for Advanced & Expert Users
Can some one help me in connecting to oracle through unix shell scripts with examples.
Narayana Gupta (1 Reply)
Discussion started by: guptan
10. UNIX for Dummies Questions & Answers
Does anyone know how to call an Oracle stored procedure from a Unix script? (1 Reply)
Discussion started by: ssmiths001