Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to assign a shell variable to a NUMBER parameter in pl/sql?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to assign a shell variable to a NUMBER parameter in pl/sql?
# 1  
Old 12-24-2011
MySQL How to assign a shell variable to a NUMBER parameter in pl/sql?
I have the below script running for generating file from PL/SQL stored procedure. I need to declare a shell variable and then pass this to sqlplus command to pass the same as a INPUT parameter for the stored procedure. Please help to do this.

Code:
#!/bin/sh
minlimit=0
maxlimit=10
size=100
while [ $maxlimit -gt $size ] do
outputvar=`sqlplus -S $username/$password@$tnsname << EOF
set echo off
variable var CLOB
begin
        pack.proc($minlimit,$maxlimit,:var);
end;
/
exit;
EOF
`
maxlimit=maxlimit+10
done

Last edited by Franklin52; 12-24-2011 at 10:24 AM.. Reason: Correcting code tags
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Assign number of records to a variable

How does one assign a variable, x to equal the number of records in a different file. I have a simple command such as below: awk -F "\t" '(NR>5) { if(($x == "0/0")) { print $0} }' a.txt > a1.txt but I want x to equal the number of records in a different file, b.txt (10 Replies)
Discussion started by: Geneanalyst
10 Replies

2. Shell Programming and Scripting

How to Assign the Output of an SQL Query to a Variable?

Hi iam new to shell scripting how to declare variables as redshift query and I have to compare two counts by using if condition . ex:count=select count(*) from prd; select count(*) from prd; select count(*) from tag; can any one help me . Please use CODE tags when displaying... (1 Reply)
Discussion started by: sam526
1 Replies

3. Shell Programming and Scripting

Assign the return value of the SQL to a variable in UNIX

Hi I am new to UNIX. I am trying the below and getting the error. I am trying to assign the variable with the value of the query result. I want this value to use in the next steps. Created UNIX file (Batch.sh) as below #!/bin/ksh sqlplus callidus/callidus4u@attstcal @Batch.sql ... (2 Replies)
Discussion started by: KrishBalu
2 Replies

4. Shell Programming and Scripting

Assign a variable to number of lines in a file

Hello Gurus, Here is my requirement. I need to find the number of lines in a file and need to assign it to a variable. This is what I did and not wroking. #!/bin/ksh set -xv Src_Path=/mac/dev/Generic/SrcFiles Src_Count=wc -l ${Src_Path}/FILE_JUNE.txt Count_file = $Src_Count | awk -F... (2 Replies)
Discussion started by: thummi9090
2 Replies

5. UNIX for Dummies Questions & Answers

Assign SQL result in shell variable

Hi im trying to assign the result of the db2 command to a variable inside a shell script... : tab_cnt=`db2 "select count(*) from syscat.tables where tabname = 'ABC' and tabschema = 'MATT01'" |head -4|tail +4|cut -c 11` : echo $tab_cnt when i echo im getting a blank value.. im expecting... (1 Reply)
Discussion started by: matt01
1 Replies

6. Shell Programming and Scripting

Get letter from number and assign to a variable

Hi to all in forum, I'm trying to convert the letter number between 1 (A) and 26 (Z), that part is working, my issue is how to assign the printf output to a variable:LetterNumber=10 printf "\x$(printf %x $((${LetterNumber}+64)))" $ J #The problem, how to assign printf output (J in this... (8 Replies)
Discussion started by: Ophiuchus
8 Replies

7. Shell Programming and Scripting

Number lines of file and assign variable to each number

I have a file with a list of config files numbered on the lefthand side 1-300. I need to have bash read each lines number and assign it to a variable so it can be chosen by the user called by the script later. Ex. 1 some data 2 something else 3 more stuff which number do you... (1 Reply)
Discussion started by: glev2005
1 Replies

8. Shell Programming and Scripting

How to assign the result of a SQL command to more than one variable in shell script.

Hi Friends... Please assist me to assign the result of a SQL query that results two column, to two variables. Pls find the below code that I write for assigning one column to one variable. and please correct if anything wrong.. #! /bin/sh no=' sqlplus -s uname/password@DBname... (4 Replies)
Discussion started by: little_wonder
4 Replies

9. Shell Programming and Scripting

how to assign sql output data to shell script variable

Hi Guys ! I am new to unix and want to find out how we can make sql statement data to shell script variable? Any help/suggestion is greatly appreciated -Chandra (1 Reply)
Discussion started by: kattics
1 Replies

10. Shell Programming and Scripting

Assign value to a variable in a parameter file

Hi, I have a parameter file and it contains following items $ cat TransactionParams From_Date_Parm=2005-02-25 To_Date_Parm=2005-05-25 Extract_Root_Parm=/detld1/etl/ascential/Ascential/DataStage/Projects/CTI_London/IAM Extract_Type_Parm=Transaction EDW_Database_Parm=hdw_erks... (2 Replies)
Discussion started by: gopskrish
2 Replies
Login or Register to Ask a Question

LEARN ABOUT LINUX

stdlib

STDLIB(7)						   Erlang Application Definition						 STDLIB(7)

NAME

       STDLIB - The STDLIB Application

DESCRIPTION

       The STDLIB is mandatory in the sense that the minimal system based on Erlang/OTP consists of Kernel and STDLIB. The STDLIB application con-
       tains no services.

CONFIGURATION

       The following configuration parameters are defined for the STDLIB application. See app(5) for more information about configuration  parame-
       ters.

	 shell_esc = icl | abort :
	   This parameter can be used to alter the behaviour of the Erlang shell when ^G is pressed.

	 restricted_shell = module() :
	   This parameter can be used to run the Erlang shell in restricted mode.

	 shell_catch_exception = bool() :
	   This parameter can be used to set the exception handling of the Erlang shell's evaluator process.

	 shell_history_length = integer() >= 0 :
	   This parameter can be used to determine how many commands are saved by the Erlang shell.

	 shell_prompt_func = {Mod, Func} | default :
	   where

	   * Mod = atom()

	   * Func = atom()

	   This parameter can be used to set a customized Erlang shell prompt function.

	 shell_saved_results = integer() >= 0 :
	   This parameter can be used to determine how many results are saved by the Erlang shell.

SEE ALSO

       app(5) , application(3erl) , shell(3erl) ,

Ericsson AB							   stdlib 1.17.3							 STDLIB(7)