Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
hi,
I am using a shell script from where i will be conecting to sqlplus..
i am having a problem in passing a variable to sqlplus query..
i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am... (3 Replies)
I have shell script which will try to login to SQL Plus and retrieve some data, based on the outcome i will proceed further
Below is the content of the file
pebblz02% cat test1.ksh
#! /bin/ksh
dummyvar=`sqlplus -S csm_admin/csm_admin@SIDNAME <<EOF echo hi; exit; EOF`
Error message on... (0 Replies)
UNIX Gods,
I'll be running this script from CRON. I need to log the status of each of the six sqlplus calls into a file when this job is kicked off. Any suggestions?
Thanks in advance.
#!/bin/ksh
export USAGE="USAGE: `basename $0` -e <DBUSER> <DBPASSWD> <TNSNAME>"
if ; then
... (2 Replies)
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
I have a variable $WORDS that contains a string
Then i want to use sed to break it up.
echo $WORDS | sed 's// /g'
I tried setting this as a variable by doing
WORDS2=`echo $WORDS | sed 's// /g'`
But when i do this it does not return me to the prompt properly
ie.
jmpprd-v1>
jmpprd-v1>... (4 Replies)
Hi ,
I am using below code :
for i in `ps -ef|grep pmon|awk {' print $8 '}|cut -f3 -d'_'|grep -v '^grep'`
do
ORACLE_SID=$i
export ORACLE_SID;
dest=`sqlplus "/ as sysdba" <<EOF
set heading off feedback on verify off
select DESTINATION from v\\$archive_dest where target in... (5 Replies)
Discussion started by: admin_db
5 Replies
LEARN ABOUT DEBIAN
gcstar
GCSTAR(1) Linux User's Manual GCSTAR(1)NAME
GCstar - Personal collection manager
SYNOPSIS
gcstar [-u UPDATE-OPTIONS] [-x EXECUTE-OPTIONS] [FILENAME]
DESCRIPTION
GCstar is a Gtk2 program used to manage personal collections.
OPTIONS
Without any option, it will open FILENAME if specified or the previously opened file. There are also two groups of options.
UPDATE-OPTIONS
-u, --update
Tell GCstar to look for available updates
-a, --all
Update all components
-c, --collection
Update collection models
-w, --website
Update plugins to download information
-i, --import
Update plugins to import data
-e, --export
Update plugins to export data
-l, --lang
Update translations
-n, --noproxy
Don't ask for a proxy
EXECUTE-OPTIONS
-x, --execute
Enter non-interactive mode
-c, --collection MODEL
Specify the collection type
-w, --website PLUGIN
Specify the plugin to use to download information
-i, --import PLUGIN
Specify the plugin to use to import a collection
-e, --export PLUGIN
Specify the plugin to use to export the collection
-f, --fields FILENAME
File containing fields list to use for import/export
-o, --output FILENAME
Write output in FILENAME instead of standard output
--download TITLE
Search for the item with TITLE as name
--importprefs PREFERENCES
Preferences for the import plugin
--exportprefs PREFERENCES
Preferences for the export plugin
Preferences for import/export plugins are specified using this schema
Key1=>Value1,Key2=>Value2
ENVIRONMENT
HOME Used to define following variables if needed
XDG_CONFIG_HOME
Where configuration files should be stored. If not defined: $HOME/.config
XDG_DATA_HOME
Where some data will be stored. If not defined: $HOME/.local/share
BUGS REPORTING
To report bugs, please use this forum:
http://forums.gcstar.org/viewforum.php?id=4
AUTHORS
Tian <tian@c-sait.net>
http://www.gcstar.org/
GCstar 17 August 2006 GCSTAR(1)