Creating IN list in PLSQL script dynamically by using shell script Post: 302910770

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script dynamically case in VAR

Hallo, I am working on a kdialog. This shall be able to load the required commands from a .conf file. First step runs good by loading the entries (selectabel entries) in a variable: MIRRORSELECT=$(kdialog --radiolist "Select your nearest mirror" $VAR1) The kdialog is accordingly correct...

2. Programming

UNIX Shell Script to Create a Document of a PLSQL code.

Hi All, I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not...

3. Shell Programming and Scripting

Shell Script to Parse PLSQL code?

4. Shell Programming and Scripting

Dynamically creating text files using shell script

Hi All, I want to create a shell script which dynamically create text files. i am using the following script $i=1 while do cat > test_$i.txt done but while running the script it was stopping(the cursor not going to next step, i have to enter ctrl+c to make it stop). it is creating only...

5. Programming

running PLSQL scripts through shell script

I am running the following ealth checks on my server there are two databases in my server . MODEL1 and MODEL2 i connect with the first database as sqlplus model1/password Then i exceute a query select x from table

6. Programming

Executing shell script from PLSQL

Hi All, I have a requirement to mv a file in unix from plsql procedure. for that i have created a java host procedure, a host_command, given all grants as per ORACLE-BASE - Oracle8i Shell Commands From PL/SQL but i am getting an error ""Process err :/bin/sh: mv Not Found"" kindly let me...

7. Shell Programming and Scripting

Execute shell script from plsql trigger

Hi, I have been assigned a job which requires me to send mails from unix(Mailx) upon on certain actions triggered in the database. On insert/update of a certain field into one of the database tables the shell script present in Unix box responsible to send mail though mailx needs to be triggered...

8. Shell Programming and Scripting

Creating variables dynamically and using it in script?

Hi, I have a problem that I am trying to solve and would greatly appreciate some input to solve this. I have a file containing variable length of line. Each line in the file has values separated by "," and i need to grep for these values in a some files. For example below is a sample file with 3...

9. Shell Programming and Scripting

calling a plsql procedure through shell script

I have a plsql procedure inside a package which is having one IN parameter .I want to call that procedure through a shell script and that IN parameter is a column of a table in the database. So my requirement is that i need to loop all the entries of that IN parameter from the table through shell...

10. Homework & Coursework Questions

How to Dynamically Pass Parameter to plsql Function & Capture its Output Value in a Shell Variable?

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: 2. Relevant commands, code, scripts, algorithms: #! /bin/ksh v="ORG_ID" ...

LEARN ABOUT OPENSOLARIS

shcomp

shcomp(1)							   User Commands							 shcomp(1)

NAME

       shcomp - compile a ksh93 shell script

SYNOPSIS

       shcomp [-nv] [infile [outfile]]

       shcomp -D [infile [outfile]]

DESCRIPTION

       If  the	-D  option  is not specified, shcomp takes a shell script, infile, and creates a binary format file, outfile, that ksh93 reads and
       executes with the same effect as the original script.

       Aliases are processed as the script is read. Alias definitions whose value requires variable expansion will not work correctly.

OPTIONS

       The following options are supported:

       -D	       Generate a list of strings that need to be placed in a message catalog for internationalization.
       --dictionary
		       With this option, all double quoted strings that are preceded by $ are printed, one literal  per  line.	A  literal  $"foo"
		       prints  "foo" in the output. These are the messages that need to be translated to locale specific versions for internation-
		       alization.

       -n	       Display warning messages for obsolete or non-conforming constructs.
       --noexec

       -v	       Display input from infile onto standard error as it reads it.
       --verbose

OPERANDS

       The following operands are supported:

       infile	  Specifies the name of the file that contains the shell script to be used as input.

		  If infile is omitted, the shell script is read from standard input.

       outfile	  Specifies the name of the output file.

		  If outfile is omitted, both modes write their results to standard output.

EXIT STATUS

       The following exit values are returned:

       0     Successful completion.

       >0    An error occurred.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |CSI			     |Enabled			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |See below.		   |
       +-----------------------------+-----------------------------+

       The command-line interface and the system variables are Committed. The compiled shell code format is Private. The output of the	-D  option
       is Volatile.

SEE ALSO

       ksh93(1), attributes(5)

SunOS 5.11							    27 Jan 2009 							 shcomp(1)