Control not returning from Sqlplus to calling UNIX shell script. Post: 302995672

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting Control not returning from Sqlplus to calling UNIX shell script. Post 302995672 by RicardoQ on Monday 10th of April 2017 11:44:17 AM

Old

04-10-2017

Registered User

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:

Mod Comment

edit by bakunin: fixed your link

Last edited by bakunin; 04-10-2017 at 03:40 PM..

RicardoQ

View Public Profile for RicardoQ

Find all posts by RicardoQ

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

calling sqlplus from shell

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

Returning Strings from C program to Unix shell script

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

3. Programming

Returning Strings from C program to Unix shell script

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

4. UNIX for Advanced & Expert Users

Returning a value to a calling script

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

Error in calling store procedure using SQLPLUS in unix

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

6. UNIX for Dummies Questions & Answers

calling a unix shell script from sqlplus

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.

7. Shell Programming and Scripting

Calling sqlplus from Korn shell heredoc issue

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

8. Shell Programming and Scripting

Control from UNIX script is not returning to the Parent program

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

9. Shell Programming and Scripting

Control not returning from Sqlplus to calling UNIX shell script.

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

10. UNIX for Beginners Questions & Answers

SQLPLUS calling Via Script

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

LEARN ABOUT LINUX

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)