Need Help: Shell script to call sql session with variables stored in .txt file Post: 302922903

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how can a call shell script from pl/sql

I like to call a shell script from pl/sql proceduere and i have to use the shell script return value in that procedure. i am using oracle 9i and cygwin. can any one suggest me how can i do this

2. Shell Programming and Scripting

how can i call a shell script from pl/sql

I would like to call the shell script from pl/sql and i need to uses the value returned by the shell script in pl/sql procedure. can any one suggest me how can i do that?

3. Shell Programming and Scripting

how to call shell script from pl/sql loop

Hello, I am doing a shell script which contain a pl/sql loop to search for 3 values, i would like to call another shell script inside this sql loop each time it find the values. so how can i call shell script from pl/sql using its variables, any idea? Here is idea about the code: my...

4. Shell Programming and Scripting

call shell script from pl/sql block

Hi Experts, I want to call script_name.ksh as many time as id in customer table and also pass it as a parameter to script. someting Like below. for i in select id from customer do ./script_name.ksh $i & done I have figured out how to have ID from customer but now how to call...

5. Shell Programming and Scripting

How to call stored procedure with CLOB out parameter from shell script?

I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable?

6. UNIX for Advanced & Expert Users

call sql through shell script

Hi i am not able to connect sqlplus my script is as follows $ORACLE_HOME/bin/sqlplus << ! > /tmp/extract/DM.txt and output is SQL*Plus: Release 11.1.0.7.0 - Production on Wed Jan 18 02:53:54 2012 Copyright (c) 1982, 2008, Oracle. All rights reserved. Enter user-name: t175481...

7. Shell Programming and Scripting

Need to write shell script for my .sql file call

Hi Guys, I need to write a simple shell script which will generate a .csv file/report by calling .sql file inside a shell script. Can somebody help me on this. Thanks in advance! Regards, LK

8. Shell Programming and Scripting

How to call SQL Loader in shell script?

HI Experts, I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into the table. Also i...

9. Programming

Writing a UNIX shell script to call a C function and redirecting data to a .txt file

Hi, I am complete new to C programming and shell scripting. I just wrote a simple C code to calculate integral using trapezoid rule. I am prompting user to pass me No. of equally spaced points , N , upper and lower limit. My code looks as follows so far: #include<stdio.h> #include<string.h>...

10. Shell Programming and Scripting

Shell script to call sql file

hi , the below script contains sql query and after executed it sends the output of the query (output.txt) to an email body with conditional subject line based on the output of all_counts_match.txt. i want to make this script generic so that it can accept the sql file as parameter and can...

LEARN ABOUT DEBIAN

xsession.options

Xsession.options(5)						File Formats Manual					       Xsession.options(5)

NAME

       Xsession.options - configuration options for Xsession(5)

DESCRIPTION

       /etc/X11/Xsession.options  contains a set of flags that determine some of the behavior of the Xsession(5) Bourne shell (sh(1)) script.  See
       the Xsession(5) manpage for further information.

       Xsession.options may contain comments, which begin with a hash mark ('#') and end at the next newline, just like comments in shell scripts.
       The  rest  of  the  file consists of options which are expressed as words separated by hyphens, with only one option per line.  Options are
       enabled by simply placing them in the file; they are disabled by prefixing the option name with 'no-'.

       Available options are:

       allow-failsafe
	      If the 'failsafe' argument is passed to the Xsession script, an emergency X session is  invoked,	consisting  of	only  an  x-termi-
	      nal-emulator(1)  in  the	upper-left hand corner of the screen.  No window manager is started.  If an x-terminal-emulator program is
	      not available, the session exits immediately.

       allow-user-resources
	      If users have a file called .Xresources in their home directories, these resources will be merged with the default X resources  when
	      they log in.

       allow-user-xsession
	      If users have an executable file called .xsession in their home directories, it can be used as the startup program for the X session
	      (see Xsession(5)).  If the file is present but not executable, it may still be used, but is assumed to be a Bourne shell script, and
	      executed with sh(1).

       use-session-dbus
	      If the dbus package is installed, the session bus will be activated at X session launch.

       use-ssh-agent
	      If  the  ssh-agent(1)  program  is  available  and  no agent process appears to be running already, the X session will be invoked by
	      exec'ing ssh-agent with the startup command, instead of the startup command directly.

       All of the above options are enabled by default.  Additional options may be supported by the local  administrator.   Xsession(5)  describes
       how this is accomplished.

AUTHORS

       Stephen Early, Mark Eichin, and Branden Robinson developed Debian's X session handling scripts.	Branden Robinson wrote this manual page.

SEE ALSO

       Xsession(5), ssh-agent(1), x-terminal-emulator(1)

Debian Project							    2004-10-31						       Xsession.options(5)