03-02-2010
IMake use of a procedure or a function in the plsql script. Return the value of count from the function as a return value or an OUT parameter for a procedure. Try it out and let us know what you come up with.
cheers,
Devaraj Takhellambam
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi, I need help again. When I run this shell script, it only runs the unld_date.sql piece and exits. How can I structure this to run all the way to the end? When I don't have the unld_date.sql piece in here, everything runs fine from the date compare piece all the way to the end. Thanks in... (5 Replies)
Discussion started by: siog
5 Replies
2. UNIX for Advanced & Expert Users
Could anyone please help me. I have a function in plsql that returns a number. But i am listing some records through that function using DBMS_OUTPUT.PUT_LINE. I want to catch those records by executing this function through a unix script. The following shows what i did
echo "Connected from... (2 Replies)
Discussion started by: cobroraj
2 Replies
3. Shell Programming and Scripting
Hello,
I want to know is it possible to pass a block of sentence using bash.
For example,
I have a script called Test.sh that takes in $1 and $2.
and I'm calling Test.sh in a.sh
so
in a.sh
Test.sh '' 'This is a sentence'
Because block are separated by space so when I do that, I get... (6 Replies)
Discussion started by: katrvu
6 Replies
4. UNIX for Advanced & Expert Users
Hi
Can anyone please let me know how to call unix scripts from sql or plsql ASAP. (2 Replies)
Discussion started by: ksailesh
2 Replies
5. Programming
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... (1 Reply)
Discussion started by: gauravsachan
1 Replies
6. Shell Programming and Scripting
Hi all,
I need to pass a value from Unix to plsql block so that i can use the variable to in where caluse to get the desired output.
I tried useing $variable_name, but it doesn't work.
Any kind of help is appreciated.
Thanks in advance. (3 Replies)
Discussion started by: bankimmehta
3 Replies
7. Shell Programming and Scripting
I have written a script which works fine, to remove patterns contained in EXCLUDE.DAT from input.txt
awk 'BEGIN {n=0;while (getline < "EXCLUDE.DAT" > 0){ex=$0;n++}} {for(var in ex){print var "-" ex $0 ;i++}}' input.txt
The last problem I need to solve is how to pass the file... (3 Replies)
Discussion started by: nixie
3 Replies
8. Shell Programming and Scripting
myscript.sh
#!/bin/bash
ARGA=$1
if ; then
echo "${ARGA}:Confirmed"
else
echo "${ARGA}:Unconfirmed"
fi
when I run the above script from the command line, i run it as:
./myscript.sh jsmith
now some times, i need to runn it this way: (8 Replies)
Discussion started by: SkySmart
8 Replies
9. Homework & Coursework Questions
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"
... (2 Replies)
Discussion started by: sujitdas2104
2 Replies
10. UNIX for Beginners Questions & Answers
I just want to make sure I am understanding how to pass a config file to a bash script . In the below I pass to arguments to a script, then define them in the script as id and config. I then source config using ., if I understand correctly the variables in the config file can now be used by the... (11 Replies)
Discussion started by: cmccabe
11 Replies
LEARN ABOUT DEBIAN
xsil2graphics
XSIL2GRAPHICS(1) User Contributed Perl Documentation XSIL2GRAPHICS(1)
NAME
xsil2graphics - generate scripts to load xsil output data files
SYNOPSIS
xsil2graphics [options] <xsil_file>
DESCRIPTION
Utility program bundled with xmds, used to generate scripts that load simulation output data into either matlab (http://www.mathworks.com)
or scilab (http://www.scilab.org), which are then used to manipulate the results further if necessary and then to present the results
graphically.
Matlab
To generate a matlab m-file, from the xsil file data_file.xsil use the command:
bash$ xsil2graphics data_file.xsil
or
bash$ xsil2graphics --matlab data_file.xsil
Then at the matlab command prompt:
>> data_file
Scilab
To generate a scilab script file, from the xsil file data_file.xsil use the command:
bash$ xsil2graphics --scilab data_file.xsil
Then at the scilab command prompt:
--> exec('data_file.sci')
OPTIONS
-m, --matlab generate matlab m-file script to load data from the xsil data file (the default option)
-s, -scilab generate scilab script file to load data from the xsil data file
-o, --outfile <out_file> specify an alternative output script filename to the default which is the input xsil filename with the .xsil
extension changed to either .m for the matlab m-file or .sci for the scilab script file
EXAMPLES
bash$ xsil2graphics nlse.xsil
Generates the output nlse.m to load the data into matlab
bash$ xsil2graphics -m nlse.xsil
Also generates the output nlse.m but explicitly sets matlab to be the output format
bash$ xsil2graphics --scilab nlse.xsil
Generates the output nlse.sci to load the data into scilab
bash$ xsil2graphics --outfile nlse_new.m nlse.xsil
Generates the output nlse_new.m to load the data into matlab
AUTHORS
Originally written by Greg Collecutt
Maintained by Paul Cochrane with code contributed by Joe Hope
BUGS
No known bugs.
SEE ALSO
xmds(1), loadxsil(1)
http://www.xmds.org
COPYRIGHT
Copyright (C) 2000-2004
Code contributed by Greg Collecutt, Joseph Hope and Paul Cochrane
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
perl v5.8.2 2004-06-21 XSIL2GRAPHICS(1)