11-14-2001
Hi Amber,
You should be able to do somthing like...
#!/usr/bin/ksh
sqlplus -s scott/tiger@db << EOF > /tmp/result.$$
declare invar number;
declare outvar char(30);
exec myschema.mypkg.myproc(invar, outvar);
dbms_output.putline(outvar);
/
EOF
read result /tmp/result.$$
echo $result
rm -f /tmp/result.$$
exit 0
...if you do a search on the forum from "sqlplus" you should
see lots of good examples. The one above is just a quick and dirty
one.
8 More Discussions You Might Find Interesting
1. Linux
have following package installed
rpm -qa |grep ADMIN
It will give the following package installed:
ADMIN-4.0.0.1
Now I will upgrade the ADMIN package using the following command.
rpm --upgrade ADMIN-4.1.0.1
It will upgrade the ADMIN packagge to ADMIN-4.1.0.1
Now I want that... (0 Replies)
Discussion started by: amitpansuria
0 Replies
2. 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
3. AIX
Hello, I'm trying to build a (bff) package from an already installed program (clam antivirus) using mkinstallp. However, mkinstallp fails with "no such file: ./usr/lpp/<package name>/inst_root"
I'm not sure why all files get created ok except for these particular ones. Any help would be... (2 Replies)
Discussion started by: omonte
2 Replies
4. UNIX for Advanced & Expert Users
Friends,
Please let meknow, How we can find the dependancies of .dstream package & .rpm package before installation ?
For AIX, We can use the inutoc . command to create the .toc file for the bff package, What about Solaris & Linux ? (0 Replies)
Discussion started by: yb4779
0 Replies
5. Programming
HI,
When am creating one package body,its throwing error,
Code which am using to create is:
CREATE OR REPLACE PACKAGE BODY "MAMPROD"."PKG_QS_ADMIN" AS
-- ============================================================================
PROCEDURE CREATE_PARAMETERS
IS
BEGIN
... (2 Replies)
Discussion started by: Sanal
2 Replies
6. Linux
Dear all,
I would like to install a new version of package without remove old version on Centos and vice versa.
Please give me advice!
thanks much, (2 Replies)
Discussion started by: all4cfa
2 Replies
7. UNIX for Dummies Questions & Answers
Hello,
i have downloaded an rpm package "hadoop-0.20.205.0-1.amd64.rpm"
in /usr/local/ directory.
I'm trying to install the rpm package in a new path/location (/usr/local/hadoop-0.20.205), but i can't.
I did:
1st try: Didn't work
sudo rpm -i --prefix=/usr/local/hadoop-0.20.205... (1 Reply)
Discussion started by: g_p
1 Replies
8. Emergency UNIX and Linux Support
Hello,
i have installed a package by using the command
sudo rpm -i filepackage.rpm
package filepackage is already installed
when i try to remove it, i get an error saying "is not installed":
sudo rpm -e filepackage.rpm
error: package filepackage is not installed
How can... (4 Replies)
Discussion started by: g_p
4 Replies
LEARN ABOUT DEBIAN
dh-exec-install
DH-EXEC-INSTALL(1) dh-exec DH-EXEC-INSTALL(1)
NAME
dh-exec-install - Install (and possibly rename) files.
SYNOPSIS
#! /usr/bin/dh-exec
debian/default.conf => /etc/my-package/start.conf
usr/bin/*
DESCRIPTION
Being a sub-command of dh-exec(1), this program must not be ran directly, but through dh-exec, which automatically runs all available
sub-commands if run bare; or explicitly with dh-exec --with=install.
It is meant to be used for dh_install(1) files, and those alone. If it finds that its input is not such a file, it will do nothing, but
echo back the contents.
The purpose of the program is to extend dh_install(1)'s functionality, by allowing to specify a destination filename.
This can be accomplished by a special syntax: the " => " mark between a source and a destination means that the source file should be
installed with the specified destination name.
For obvious reasons, the source must not be a wildcard, and the destination in this case must be a file, and not a directory.
All other non-comment lines are left alone.
RESTRICTIONS
Due to the way executable scripts are called from debhelper(1), there is no way to know what options were used for the original
dh_install(1). This means, that the --sourcedir option of dh_install(1) will not work correctly when dh-exec-install is in use.
IMPLEMENTATION
Internally, the renaming happens by creating a temporary directory under debian/tmp/, and copying (or moving, if the source was under
debian/tmp/ to begin with) the file there, with the new name.
This is done this way to allow dh_install(1) to do the real copying, and allow its options to continue working, even when renaming is
involved.
The temporary directory is put under debian/tmp so that it will be cleaned by dh_prep(1) when the clean target gets to run. Thus, no extra
code is needed anywhere to clean up the renamed files.
ENVIRONMENT
DH_EXEC_SCRIPTDIR
Indicates which directory the command-specific scripts should be sought for. If not specified, scripts will be searched for in
/usr/share/dh-exec/.
FILES
$DH_EXEC_SCRIPTDIR/dh-exec-install-*
The various scripts for the higher-level program.
SEE ALSO
debhelper(1), dh-exec(1), dh_install(1)
AUTHOR
dh-exec-install is copyright (C) 2011-2012 by Gergely Nagy <algernon@madhouse-project.org>.
2012-05-03 DH-EXEC-INSTALL(1)