Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to pass a oracle variable back to the shell script
Top Forums UNIX for Dummies Questions & Answers How to pass a oracle variable back to the shell script Post 77409 by Jtrinh on Friday 8th of July 2005 12:40:05 AM
Old 07-08-2005
How to pass a oracle variable back to the shell script
Hi,

I am calling an oracle function that returns a number (either 0 or 2), how do I pass that pass to the wrapping shell script as I would like to do other things based on the value returned by the oracle function.

Your help will be appreciated.

--------------------------
sqlplus / << ENDPROG
declare
return_code integer;
begin
return_code := kf_pkg_load.df_validate_file('SAS','20050612',null,null,null,null,null,null,null,null);
commit;
end;
/
exit;
ENDPROG
---------------------------
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to Pass variable to shell Script

Hi , i am beginner to Unix, I have one small script which execute java programme,it has java command input output structure . Right now i have given Input output structure manually that is on same directory, now how can i pass that by commandline #!/bin/sh java Classjava input.txt... (5 Replies)
Discussion started by: sam70
5 Replies

2. UNIX for Dummies Questions & Answers

how to pass values from oracle sql plus to unix shell script

how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies

3. UNIX for Dummies Questions & Answers

How to pass Shell script variable to awk

Hi, I have a shell script with an ambedded awk script. i need to pass a script variable to the awk script. Please help. Thanks in advance Himani (3 Replies)
Discussion started by: HIMANI
3 Replies

4. Shell Programming and Scripting

Is it possible to pass variable from awk to shell back

I am passing a varaible to from Shell to awk then I am doing some maniplation for that variable inside awk. I want that maniplated variable value back to shell , Is this possible .Please let me know. (12 Replies)
Discussion started by: unishiva
12 Replies

5. Shell Programming and Scripting

pass variable from awk to shell script

Hello Experts, Actually I was searching for a solution here in this forum , but didn't get what exactly I want . Is this possible to do in awk ? I am trying to do some thing like below in ksh script . Upto my knowledge I can pass shell script to awk with "-v " option. But I... (3 Replies)
Discussion started by: user_prady
3 Replies

6. UNIX for Dummies Questions & Answers

Pass value back to unix variable

i had this unix korn shell code that connects to oracle database and execute the oracle procedure. i need to add a variable that indicates the oracle procedure failed. basically the variable is to check if the oracle procedure failed it will assign 1 and when the variable is equal to 1 it will not... (4 Replies)
Discussion started by: wtolentino
4 Replies

7. Shell Programming and Scripting

Unable to pass shell script variable to awk command in same shell script

I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist. diff=$1$2.diff id=$2 new=new_$diff echo "My id is $1" echo "I want to sync for user account $id" ##awk command I am using is as below cat $diff | awk... (2 Replies)
Discussion started by: Ashunayak
2 Replies

8. Shell Programming and Scripting

Pass a variable string in To_Date Oracle function in shell script

Hello, I am trying to execute an SQL query from shell script. A part of script is something like this: fromDate=`echo $(date +"%F%T") | sed "s/-//g" | sed "s/://g"` $ORACLE_HOME/sqlplus -s /nolog <<EOD1 connect $COSDBUID/$COSDBPWD@$COSDBSID spool... (4 Replies)
Discussion started by: sanketpatel.86
4 Replies

9. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

Hi all, $ echo $SHELL /bin/bash Requirement - How to pass oracle sql script as argument to unix shell script? $ ./output.sh users.sql Below are the shell scripts and the oracle sql file in the same folder. Shell Script $ cat output.sh #!/bin/bash .... (7 Replies)
Discussion started by: a1_win
7 Replies

10. Shell Programming and Scripting

Need to pass Oracle SQL output to Linux and back... Help!

Hi all, Hopefully you can help. This is what I'm trying to achieve: Obtain a list of usernames out of an Oracle Database Based on this list, link each username with an Oracle Internet Directory (OID) GUID Using the username and GUID perform a database update for all users Here are the... (7 Replies)
Discussion started by: exm
7 Replies

LEARN ABOUT DEBIAN

make-jpkg

MAKE-JPKG(1)						      General Commands Manual						      MAKE-JPKG(1)

NAME

       make-jpkg - builds Debian packages from Java binary distributions

SYNOPSIS

       make-jpkg [OPTION]... [FILE]

DESCRIPTION

       make-jpkg builds a Debian package from the given Java distribution FILE.

       Supported java binary distributions currently include:
	 * Oracle (http://www.oracle.com/technetwork/java/javase/downloads) :
	   - The J2SE Development Kit (JDK), version 6 (update >= 10), 7
	   - The J2SE Runtime Environment (JRE), version 6 (update >= 10), 7
	   - The J2SE API Javadoc, version 6 (update >= 10), 7
	 (Choose tar.gz archives or self-extracting archives, do _not_ choose the RPM!)

       The following options are recognized:

       --full-name NAME
	      full name used in the maintainer field of the package

       --email EMAIL
	      email address used in the maintainer field of the package

       --changes
	      create a .changes file

       --revision
	      add debian revision

       --help display help text and exit

       --version
	      output version information and exit

       Download  a  supported Java RE or SDK or API tar.gz or self-extracting archive from http://www.oracle.com/technetwork/java/javase/downloads
       and execute make-jpkg file with the downloaded file. The program asks the user for additional information and builds a Debian binary  pack-
       age in the current directory.

       The program requires about 200 MB free disk space in a temporary directory. The temporary directory defaults to /tmp but you can specify an
       alternate directory by setting the environment variable TMPDIR.

EXAMPLE

       To install Oracle(TM) 7 Standard Edition JDK, download a release  -  64	bits  version  of  update  2  from  http://www.oracle.com/technet-
       work/java/javase/downloads/jdk-7u2-download-1377129.html in this example - and invoke make-jpkg:

	      make-jpkg <path_to_download_directory>/jdk-7u2-linux-x64.tar.gz

       This generate a Debian package in the current directory, that can be installed using dpkg:

	      dpkg -i oracle-j2sdk1.7_1.7.0+update2_amd64.deb

       When you're done, you can delete initial download as well as generated package:

	      rm <path_to_download_directory>/jdk-7u2-linux-x64.tar.gz oracle-j2sdk1.7_1.7.0+update2_amd64.deb

ENVIRONMENT

       TMPDIR base directory used for temporary files (defaults to /tmp)

       J2SE_PACKAGE_FULL_NAME
	      full name used in the maintainer field of the package; if none is supplied then the default of "Debian Java Maintainers" is used.

       J2SE_PACKAGE_EMAIL
	      email   address	used  in  the  maintainer  field  of  the  package;  if  none  is  supplied  the  default  of  "pkg-java-maintain-
	      ers@lists.alioth.debian.org" is used.

SEE ALSO

       update-java-alternatives(1)

AUTHOR

       This manual page was written by Hubert Schmid <j2se-package@z42.de>.

       It is now maintained by the Debian Java Maintainers <pkg-java-maintainers@lists.alioth.debian.org>.

								 January 22, 2012						      MAKE-JPKG(1)
All times are GMT -4. The time now is 10:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy