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:
Code:
#! /bin/ksh
v="ORG_ID"
get_next_xfer_id ()
{
NEXT_ID=$(sqlplus -s $1 <<\!
set pages 0 feed off
select bolinf.brok_fndload_pkg.brok_fndload_profile_chk('$2')
from dual;
!
)
}
get_next_xfer_id $1 $v
echo $NEXT_ID
When I am passing like this function it is not working.
Code:
#! /bin/ksh
get_next_xfer_id ()
{
NEXT_ID=$(sqlplus -s $1 <<\!
set pages 0 feed off
select bolinf.brok_fndload_pkg.brok_fndload_profile_chk('ORG_ID')
from dual;
!
)
}
get_next_xfer_id $1
echo $NEXT_ID
when I am passing like above like i am hardcoding the paramter in function the plsql function is working .
Please let me know how to pass the parameter dynamically to plssql function as well at the same time capture the output value in a shell variable 3. The attempts at a solution (include all code and scripts):
4. Complete Name of School (University), City (State), Country, Name of Professor, and Course Number (Link to Course):
Note: Without school/professor/course information, you will be banned if you post here! You must complete the entire template (not just parts of it).
Oracle India, Bangalore,India
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by sujitdas2104; 08-08-2017 at 10:00 AM..
Reason: Added CODE tags.
Suppose I have a unix variable called RGNM which is holding a value. Now I want to call a plsql function in my script. THis plsql function takes one IN parameter. I want to pass my UNIX VARIABLE Value to the plsql function. Can i just give it by giving $RGNM in the function after calling sqlplus... (1 Reply)
Hi there!
I'm trying to write a script that will capture output from a command and assign it to a variable.
Let's say, for example, I'd like to catch from inside the script whatever the following command outputs:
ls *.aaa
and put it into a variable "listoffiles".
What I tried was:
set... (3 Replies)
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)
I need to pass a variable as a parameter from shell script into a DB2 database.
var=bhuk_1123_Q_11/22/09
select * from tbl1 where serial_id='$var';
I have tried executing it using
db2 -tvf scriptname
Somebody please help me out with this. It is throwing an error. Please tell me how... (2 Replies)
Hello,
Can anyone guide me tin passing parameters into user defined function of shell script (KSH).
Here is my code,
InsertRecord()
{
DB_TBL=$(sqlplus $USERID/$PASSWORD@$DATABASE << EOF
set head off
set feed off
set serveroutput on
INSERT INTO TBL1 ( OLD_VAL,
NEW_VAL,
... (7 Replies)
Hello again :)
Am currently trying to write a function which will delete a record from a file.
The code currently looks as such:
function deleteRecord() {
clear
read -p "Please enter the ID of the record you wish to remove: " strID
... (2 Replies)
Hello,
I am trying to execute an SQL query from shell script.
A part of script is something like this:
fromDate=`echo $(date +"%F%T") | sed "s/-//g" | sed "s/://g"`
$ORACLE_HOME/sqlplus -s /nolog <<EOD1
connect $COSDBUID/$COSDBPWD@$COSDBSID
spool... (4 Replies)
Hi Gurus,
I have request which needs to pass position parameter to a function. I tried below simple code, it doesn't work.
#!/bin/bash
func_1(){
echo $1
}
func_1
$ ./set_file abc
$
do I need add some to get the position para first?
thanks in advance. (3 Replies)
Discussion started by: ken6503
3 Replies
LEARN ABOUT DEBIAN
dancer::template::templatetoolkit
Dancer::Template::TemplateToolkit(3pm) User Contributed Perl Documentation Dancer::Template::TemplateToolkit(3pm)NAME
Dancer::Template::TemplateToolkit - Template Toolkit wrapper for Dancer
DESCRIPTION
This class is an interface between Dancer's template engine abstraction layer and the Template module.
This template engine is recomended for production purposes, but depends on the Template module.
In order to use this engine, use the template setting:
template: template_toolkit
This can be done in your config.yml file or directly in your app code with the set keyword.
Note that by default, Dancer configures the Template::Toolkit engine to use <% %> brackets instead of its default [% %] brackets. This
can be changed within your config file - for example:
template: template_toolkit
engines:
template_toolkit:
start_tag: '[%'
stop_tag: '%]'
You can also add any options you would normally add to the Template module's initialization. You could, for instance, enable saving the
compiled templates:
engines:
template_toolkit:
COMPILE_DIR: 'caches/templates'
COMPILE_EXT: '.ttc'
By default, Template is used, but you can configure Dancer to use a subclass with the "subclass" option.
engines:
template_toolkit:
subclass: My::Template
WRAPPER, META variables, SETs
Dancer already provides a WRAPPER-like ability, which we call a "layout". The reason we do not use TT's WRAPPER (which also makes it
incompatible with it) is because not all template systems support it. Actually, most don't.
However, you might want to use it, and be able to define META variables and regular Template::Toolkit variables.
These few steps will get you there:
o Disable the layout in Dancer
You can do this by simply commenting (or removing) the "layout" configuration in the config.yml file.
o Use Template Toolkit template engine
Change the configuration of the template to Template Toolkit:
# in config.yml
template: "template_toolkit"
o Tell the Template Toolkit engine who's your wrapper
# in config.yml
# ...
engines:
template_toolkit:
WRAPPER: layouts/main.tt
Done! Everything will work fine out of the box, including variables and META variables.
SEE ALSO
Dancer, Template
AUTHOR
This module has been written by Alexis Sukrieh
LICENSE
This module is free software and is released under the same terms as Perl itself.
perl v5.14.2 2012-01-27 Dancer::Template::TemplateToolkit(3pm)
08-08-2017
