01-15-2007
passing oracle parameters back to Shell
Hi All,
Does anyone have any solutions for passing back multiple variables back to the SHELL from a call to an ORACLE procedure:
eg
#username='scott'
#password='tiger'
#database='orcl'
username='ITGCD03D03'
password='tC5epIew'
database='ITGCD03D'
sqlplus -s $username/$password@$database<<EOF
set serveroutput on size 1000000
set verify off
VARIABLE vi_err NUMBER
VARIABLE val_err NUMBER;
begin
package.procedure(p_err_out => :vi_err
,p_validation_err_out => :val_err);
dbms_output.put_line('val_err='||:val_err);
end;
/
EXIT:vi_err
EOF
print out values of Vi_err and val_err here????
any feedback would e greatly appreciated!
Kind Regards
Satnam
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies
2. Programming
I am having a shell script which has to be called from a C program. I have to pass two parameters to this script. HOw can I do that?
eg:
int main()
{
char st1;
char str2;
// call a shell script
call_sh(str1,str2) where call_sh is the name of the shell script.
then i need to get the return... (5 Replies)
Discussion started by: Rajeshsu
5 Replies
3. Shell Programming and Scripting
Hi,
I have screen which was desined in PL/SQL Catridges in apps. In that screen some enterable fields these values r the passing parameters to create value sets, functions, menus etc in apps by using front end screens. Now in that screen i have a button. when i click that button it have to... (0 Replies)
Discussion started by: rajasekharamy
0 Replies
4. Shell Programming and Scripting
I am using grep to capture date from a file .
Since i need to use the shell script for different dates ,is it possible to pass the date parameter to the shell script
the Script is as below
grep -E "08 Aug 2008|2008-08-08"* somefile.txt>test.txt
The above script file greps the... (1 Reply)
Discussion started by: sud.tech
1 Replies
5. Shell Programming and Scripting
i have this basic piece of code that i am trying to debug to accept input parameter to be able to display a directory listing of files.
cd /u02/app/eatv/dev/out
CURDIR=`pwd`
echo directory listing of $CURDIR
echo
if ; then
ls -latr
else
ls -latr $1
fi
basically if the script... (9 Replies)
Discussion started by: wtolentino
9 Replies
6. Shell Programming and Scripting
Please help me how to pass some unix vairable to oracle. I have used below , but not displaying passed (inval) value.
calling()
{
sqlplus -s $1/$2@$3 <<EOF
begin
exec call_sql($4);
end;
exit
EOF
}
calling user pwd inst value1... (17 Replies)
Discussion started by: Jairaj
17 Replies
7. Shell Programming and Scripting
Hello,
I have this shell script that runs awk code by passing in parameters however now it doesn't work anymore with the parameters and I don't know why.
It removes duplicates from an input file based on a part of the last field and a key column. It removes the record with the older datetime... (0 Replies)
Discussion started by: script_op2a
0 Replies
8. Shell Programming and Scripting
I am trying to execute a copy command via shell script. However, on occassion, 2 or more files need to copied. How do I code for the multiple arguments? Does it matter how the files are delimited?
Example: I have a script to copy files from 1 dir to another called duplicate.csh
In most... (1 Reply)
Discussion started by: CKT_newbie88
1 Replies
9. Shell Programming and Scripting
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Discussion started by: compprog11
4 Replies
10. Shell Programming and Scripting
Hi All,
I have a shell script(test_abc.sh) with the following shell commands, which are invoking the same shell script with different parameters.
test_abc.sh
. ./test.sh abc >> test.log
. ./test.sh xyz >> test.log
. ./test.sh pys >> test.log
. ./test.sh abc >> test.log
.
.
... (4 Replies)
Discussion started by: dev.devil.1983
4 Replies
su(1) General Commands Manual su(1)
Name
su - substitute a user ID
Syntax
su [username]
su - [username]
su -f [username]
Description
The command requests the password of the specified username. If the correct password is given, changes to that username without changing
the current directory. The user environment is unchanged except for HOME and SHELL which are taken from the password file entry for user-
name. The shell that is run is also taken from the password file entry for username. The new user ID stays in force until the shell
exits.
If no username is specified, `root' is assumed. To remind the superuser of his responsibilities, the shell substitutes `#' for its usual
prompt.
Options
-f Prevents from executing the .cshrc file, making start up faster.
- Simulates a full login.
Diagnostics
Sorry
An invalid password was supplied for the specified username.
Unknown login: username
The specified username was not found in the passwd database.
No directory
The home directory for the username is not accessible at this time (only with ``-'' argument).
No shell
The shell specified in the passwd database entry for username could not be executed.
Kerberos initialization failure
Consult your system administrator.
If enhanced security features are enabled the following error messages are also possible:
Requires secure terminal
Attempt to su to UID 0 on a line that is not marked secure in
User's password has expired
Access is denied because the password for username is expired.
This account is disabled
Access is denied because the auth entry corresponding to username is marked disabled.
Files
Log file of anyone who became
root, with a date mark.
See Also
csh(1), sh(1), passwd(5yp), environ(7), edauth(8)
Security Guide for Administrators
Security Guide for Users
su(1)