04-10-2017
Control not returning from Sqlplus to calling UNIX shell script.
Hello All,
I have exactly same issue @vikas_trl had in following link:
Control not returning from Sqlplus to calling UNIX shell script.
I wonder if he or somebody else could find the issue's cause or the solution.
Any help would be appreciated!
PD: The solution provided on that thread is not even close.
Moderator's Comments:
|
|
edit by bakunin: fixed your link
|
|
Last edited by bakunin; 04-10-2017 at 03:40 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am executing the following code :-
sqlplus -s ${DATABASE_USER} |&
print -p -- 'set feed off pause off pages 0 head off veri off line 500'
print -p -- 'set term off time off serveroutput on size 1000000'
print -p -- "set sqlprompt ''"
print -p -- "SELECT run_command from... (2 Replies)
Discussion started by: suds19
2 Replies
2. Programming
Hi,
Iam calling a C program from a Unix shell script. The (C) program reads encrypted username/password from a text file , decrypts and returns the decrypted string.
Is there any way i can return the decrypted string to Unix shell program.
My shell script uses the output of the program to... (11 Replies)
Discussion started by: satguyz
11 Replies
3. Programming
Hi,
I'm having a requirement where I need to call a C program from a shell script and return the value from the C program to shell script.
I refered a thread in this forum. But using that command in the code, it is throwing an error
clear_text_password=$(get_password)
Error: bash:... (24 Replies)
Discussion started by: venkatesh_sasi
24 Replies
4. UNIX for Advanced & Expert Users
Hi. I'm trying to call a script named checkForFile.sh from within my main script named master.sh. In checkForFile.sh I want to set a value to the variable fileExist, but then I want to reference the value in the master.sh script. Whenever I attempt this the echo statement is just blank.
... (5 Replies)
Discussion started by: buechler66
5 Replies
5. Shell Programming and Scripting
Hi,
I am facing the following error in calling the stored procedure from SQLPLUS in unix environment.
SQL> set serveroutput on
SQL> var store number;
SQL> exec test_proc(:store, 200);
BEGIN TEST_PROC(:store, 200); END;
*
ERROR at line 1:
ORA-01858: a non-numeric character was found... (8 Replies)
Discussion started by: pradeep7986
8 Replies
6. UNIX for Dummies Questions & Answers
I want to execute a shell script from sqlplus prompt and get its output back to sqlplus. Is this possible?
if yes just give me an example for doing that. (2 Replies)
Discussion started by: boopathyvasagam
2 Replies
7. Shell Programming and Scripting
Hi,
I am facing an issue wherein some temporary files (here docs) are getting created in /tmp and are not getting deleted automatically.
When i check the list of open files with below command i can see one file is getting appended continuously.(In this case /tmp/sfe7h.34p)
The output is... (4 Replies)
Discussion started by: Navin_Ramdhami
4 Replies
8. Shell Programming and Scripting
Hi All,
My program flow is as below
Windows batch -- > Cygwin batch --> zsh script
There are multiple Cygwin batch scripts that are called from Windows batch file . But when i am executing the first cygwin batch script the control goes to the zsh file and executes and stoping from... (1 Reply)
Discussion started by: Hypesslearner
1 Replies
9. Shell Programming and Scripting
Hello All,
I have a UNIX script which will prepare anonymous oracle pl/sql block in a temporary file in run time and passes this file to sqlplus as given below.
cat > $v_Input_File 2>>$v_Log << EOF
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DML PARALLEL 16';
EXECUTE... (1 Reply)
Discussion started by: vikas_trl
1 Replies
10. UNIX for Beginners Questions & Answers
Hello All,
Could you please help me if i am doing anything wrong in below script, especially the sqlplus part performance wise or anything else i could improvise in the script. Thank you.
#!/bin/ksh
## Batch Obj Id
MP_BCH_OBJ_ID=$1
PASS=$2
partition=$3
## script dir... (6 Replies)
Discussion started by: Ariean
6 Replies
LEARN ABOUT POSIX
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)