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 SUNOS
export
asadmin-export(1AS) User Commands asadmin-export(1AS)NAME
asadmin-export, export - marks a variable name for automatic export to the environment of subsequent commands in multimode
SYNOPSIS
export [ name=value [ name=value]*]
Marks a variable name for automatic export to the environment of subsequent commands. All subsequent commands use the variable name values
as specified; unless you unset them or exit multimode. If only the variable name is specified, the current value of that variable name is
displayed. If the export command is used without any arguments, a list of all the exported variables and their values is displayed.
Exported shell environment variables set prior to invoking the asadmin utility are imported automatically and set as exported variables
within asadmin. Unexported environment variables cannot be read by the asadmin utility.
OPERANDS
name=value variable name and value for automatic export to the environment to be used by subsequent commands.
Example 1: Using export to list the environment variables
asadmin> export AS_ADMIN_HOST=bluestar AS_ADMIN_PORT=8000 AS_ADMIN_USER=admin AS_ADMIN_PASSWORD=password
asadmin> export AS_ADMIN_PREFIX=server1.jms-service
asadmin> export //to list the environment variables that are set
AS_ADMIN_HOST=bluestar
AS_ADMIN_PORT=8000
AS_ADMIN_USER=admin
AS_ADMIN_PASSWORD=********
AS_ADMIN_PREFIX=server1.jms-service
Where: the export command lists the environment variables that are set. In this case, the environment variables have been set to: the host
is bluestar, the port is 8000, the administrator user is admin with an associated password, and the prefix is server1.jms-service.
EXIT STATUS
0 command executed successfully
1 error in executing the command
asadmin-unset(1AS), asadmin-multimode(1AS)J2EE 1.4 SDK March 2004 asadmin-export(1AS)