Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Control not returning to UNIX when sqlplus is executed in while loop of shell script
Top Forums UNIX for Beginners Questions & Answers Control not returning to UNIX when sqlplus is executed in while loop of shell script Post 303045885 by MadeInGermany on Friday 17th of April 2020 01:43:04 AM
Old 04-17-2020
Put the end marker ! of the here doc at the very beginning of the line!
For example
Code:
   E_WLM_SQL_RESULT=`
sqlplus -s /@${E_WLM_DB} <<!
      set pagesize 0 feedback off verify off heading off echo on
      whenever SQLERROR exit SQL.SQLCODE
      whenever OSERROR exit 9
      $sql_Stmt;
      commit;
!
    `

 

10 More Discussions You Might Find Interesting

1. 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... (11 Replies)
Discussion started by: satguyz
11 Replies

2. Shell Programming and Scripting

Unix shell script couldn't be executed. Pls help!

I have wrriten a script to call sql script to do some work in database. However, the script couldn't be executed. The only information was: ksh: ./updt_attrib.ksh cannot execute. Please help me to identify where the problem is. I post script here for your reference. Thanks a lot. #!/bin/ksh ... (8 Replies)
Discussion started by: duke0001
8 Replies

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:... (24 Replies)
Discussion started by: venkatesh_sasi
24 Replies

4. Shell Programming and Scripting

returning un executed string to shell prompt

Hi all, i'm pritty new to chell scripting I'm trying to find a way to return a value to shell without it executing. is there a special character that will encase a sting including the command to a shell without executing, so waiting for the user to press enter. say i wanted to return a value... (3 Replies)
Discussion started by: jvan
3 Replies

5. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given... (6 Replies)
Discussion started by: praka
6 Replies

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. (2 Replies)
Discussion started by: boopathyvasagam
2 Replies

7. UNIX for Dummies Questions & Answers

How to send keyboard inputs toa UNIX command executed from a shell script?

I have a unix command that prompts for 'y'. How do I run this from my shell script? (4 Replies)
Discussion started by: Sree10
4 Replies

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... (1 Reply)
Discussion started by: Hypesslearner
1 Replies

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... (1 Reply)
Discussion started by: vikas_trl
1 Replies

10. Shell Programming and Scripting

Control not returning from Sqlplus to calling UNIX shell script.

Hello All, I have exactly same issue @vikas_trl had in following link: https://www.unix.com/shell-programming-and-scripting/259854-control-not-returning-sqlplus-calling-unix-shell-script.html I wonder if he or somebody else could find the issue's cause or the solution. Any help would... (4 Replies)
Discussion started by: RicardoQ
4 Replies

LEARN ABOUT DEBIAN

pdbtxt2html

pdbtxt2html(1)						      General Commands Manual						    pdbtxt2html(1)

NAME

       pdbtxt2html - Doc Text to HTML converter for Palm Pilots

SYNOPSIS

       pdbtxt2html [ -t ] file.txt [ file.html ]
       pdbtxt2html -v

DESCRIPTION

       pdbtxt2html converts text converted from a Doc(4) file via txt2pdbdoc(1) to HTML.  If no HTML filename is given, the generated HTML is sent
       to standard output.

   Document Title
       The first line of the file is used for the HTML document title.

   Bookmarks
       The last line of the file is examined and, if it contains a string enclosed between < and >, that is taken to be the bookmark marker.   The
       entire file is then scanned looking for lines beginning with it (ignoring leading whitespace).  These lines are converted to HTML headings.

       The  number  of whitespace characters after the first bookmark marker is used for heading level 1.  The level of subsequent headings is set
       to the number of whitespace characters between the bookmark marker and the bookmark text minus the number for the first bookmark plus one.

   Embedded URLs
       Valid URLs (according to RFC 1630) embedded in the text are turned into hyperlinks.  The ftp, gopher, http, https,  mailto,  news,  telnet,
       and wais URLs are recognized.

OPTIONS

       -t   Compile a table of contents and insert it between the first heading and the body.

       -v   Print the version number to standard output and exit.

EXAMPLE

       To convert a Doc file to HTML:

	    txt2pdbdoc alice.pdb alice.txt
	    pdbtxt2html alice.txt alice.html

SEE ALSO

       html2pdbtxt(1), txt2pdbdoc(1), doc(4), pdb(4)

       Tim Berners Lee.  Universal Resource Identifiers in WWW, Network Working Group of the Internet Engineering Task Force, June 1994.
	    http://info.internet.isi.edu/in-notes/rfc/files/rfc1630.txt

AUTHOR

       Paul J. Lucas <pauljlucas@mac.com>

txt2pdbdoc							 January 21, 2005						    pdbtxt2html(1)
All times are GMT -4. The time now is 02:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy