Sponsored Content
Top Forums Shell Programming and Scripting Help required to pass the parameter Post 302084266 by u263066 on Thursday 10th of August 2006 06:06:54 AM
Old 08-10-2006
Help required to pass the parameter

i am calling a pl/sql procedure through a shell script, there is one IN and 2 OUT parameter required to pass to the procedure to execute..

My procedure is XX_CITIDIRECT_EXP_PKG.main_proc and In parameter is p_period which I wanto to pass 'MAY-06'.

Can anyone figure out, whats is wrong here

HTML Code:
#!/bin/ksh
setenv TSTAMP1 "'MAY-06'"
sqlplus -silent apps/apps <<EOF
variable p_period varchar2
variable l_errbuf varchar2
variable l_errcode varchar2
execute XX_CITIDIRECT_EXP_PKG.main_proc(p_period =>$TSTAMP1,errbuf => :l_errbuf,retcode => :l_errcode);
exit;
EOF
Thanks in advanec
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Pass Parameter to Another Script

I have a piece of code that I do not want to continuously repeat. I want to call script2 from script1 and pass a parameter. Here is an example: Script1: ....... nohup ./Script2 PARAMETER ....... Script2: if # Checks if any params. then echo "No parameters passed to function." ... (4 Replies)
Discussion started by: rvprod
4 Replies

2. Shell Programming and Scripting

Pass parameter into script

I would like to write a scirpt a.sh that it first checks the first parameter of the input. If it fulfill some condition ,then run an executable program b by using all the parameter. ie. > ./a.sh 10 20 30 40 50 Then a.sh first checks the first parameter, 10, if it mathes the requirement, then... (2 Replies)
Discussion started by: alfredo
2 Replies

3. Shell Programming and Scripting

How to pass a parameter

Hi all, How to pass a parameter from a oracle pl/sql procedure parameter to shell environment and use it? (1 Reply)
Discussion started by: megh
1 Replies

4. UNIX for Dummies Questions & Answers

How to pass parameter to subroutine

I have something like cp -p <dir>filename1.dat <dir2>filename1.dat there are many other operations in it I mean that filename1.dat will keep on changing I need to write a subroutine so that i can pass filename1 or 2 or 3 .dat as parameter Thanking you in advance Any help wuld be appreciated (2 Replies)
Discussion started by: ssuresh1999
2 Replies

5. Shell Programming and Scripting

pass parameter to function

HI all I have a code like ############################################## minyear() { curryear=$1 echo $curryear } ##Main Program ## minyear exit ####### when i execute "sh scriptname 2005" output should be like 2005 but the output is blank. I guess i need to pass parameter to... (3 Replies)
Discussion started by: vasuarjula
3 Replies

6. UNIX for Dummies Questions & Answers

How to pass the parameter value to a... ?

Hello I have a simple code like this one: #!/bin/ksh VER=$1 cat /usr/text | while read line do echo $line done Let's say $1=1.0.0 and the contents of text is: abcd.cfg asdf I would like the output to be like this abcd1.0.0.cfg asdf1.0.0 I am thinking of passing the... (5 Replies)
Discussion started by: khestoi
5 Replies

7. Shell Programming and Scripting

How to pass a parameter from the terminal?

Hi, I am new in Ubuntu, I will be glud to know: 1. How to pass a parameter from the terminal to a file that I write in shell script. What is the command line I need to write in the terminal? 2. How to get the parameter in the file? What do I need to write in the file? 3. What kind of file is... (1 Reply)
Discussion started by: vess
1 Replies

8. Shell Programming and Scripting

pass parameter to SED

My script(ksh) works fine for --------------------------------------------------- sed -n '28,31p' ${l_name} >> ${LOG_DIR}/Email.txt --------------------------------------------------- But I wand to pass parrmeter to this syntax I did the following things ... (14 Replies)
Discussion started by: deep_kol
14 Replies

9. Shell Programming and Scripting

Pass parameter

Hi, I have following for loop , please let me know how to get ${TXP_EXT_TABLE_${i}_SQL} parameter with 1DAY and 7DAY values. for i in 1DAY 7DAY do ${NZSQL_DIR}/nzsql -h ${HOST} -time -v ON_ERROR_STOP=1 -f ${SQL_DIR}/${TXP_EXT_TABLE_${i}_SQL} > ${TMP_LOG_FILE} 2>&1 done ... (4 Replies)
Discussion started by: sandy162
4 Replies
Catalyst::Helper::HTML::FormFu(3pm)			User Contributed Perl Documentation		       Catalyst::Helper::HTML::FormFu(3pm)

NAME
Catalyst::Helper::HTML::FormFu - Helper to deploy HTML::FormFu template files. SYNOPSIS
script/myapp_create.pl HTML::FormFu DESCRIPTION
As of version 0.02000, HTML::FormFu doesn't use the TT template files by default - it uses in internal rendering engine. If you don't want to customise the generated markup, you don't need to use Catalyst::Helper::HTML::FormFu at all. If you want to customise the generated markup, you'll need a local copy of the template files. To create the files in the default "root/formfu" directory, run: script/myapp_create.pl HTML::FormFu To create the files in a different subdirectory of "root", pass the path as an argument. The following example would create the template files into the directory "root/forms". script/myapp_create.pl HTML::FormFu forms You'll also need to tell HTML::FormFu to use the TT renderer, this can be achieved with Catalyst::Controller::HTML::FormFu, with the following Catalyst application YAML config: --- 'Controller::HTML::FormFu': constructor: render_method: tt SUPPORT
IRC: Join #catalyst on irc.perl.org. Mailing Lists: http://lists.rawmode.org/cgi-bin/mailman/listinfo/html-widget SEE ALSO
HTML::FormFu, Catalyst::Helper AUTHOR
Carl Franks, "cfranks@cpan.org" LICENSE
This library is free software . You can redistribute it and/or modify it under the same terms as perl itself. perl v5.14.2 2011-04-04 Catalyst::Helper::HTML::FormFu(3pm)
All times are GMT -4. The time now is 06:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy