Passing parameters form unix to Oracle procedure

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Parallel execution of Oracle procedure in UNIX

i have say x number of procedure to run, ie i have one procedure which accepts variable and i need that to run in parallel and capture the error code if in case if it fails through the unix. sqlplus <EOF> exec test_t (abc,124); </EOF> sqlplus <EOF> exec test_t (abc,125); </EOF> sqlplus <EOF>...

2. UNIX for Dummies Questions & Answers

Finding Oracle form Version UNIX

I'm trying to find the version of the underlying Oracle forms from out Unix Server. I have tried frmcmp.sh -h but I get the error frmcmp.sh -h : not found Its a Unix Sun server running an oracle database Any ideas?

3. Shell Programming and Scripting

Need to run Oracle stored procedure from UNIX env

Hi Everyone, I want to create a script where i need to run the oracle stored procedure from unix script and get the output(sequence number ) into a variable which i will pass in my datastage job. Below is my stored procedure:- DECLARE P_TRANSTYPE VARCHAR2(20); ...

4. Shell Programming and Scripting

run oracle procedure in unix scripts

for j in $(du -h $1| awk '{printf("%100-s \n",$2)}') do for a in $(ls -time $(find $j -name '*.txt') | awk '{printf("\n%s %s %s %s %s",$4,$7,$8,$10,$11)}') do echo "$a">output.txt done done exit 0 echo "Password : xxxxxx " > LOG/BGH_$3.out

5. Shell Programming and Scripting

Passing unix variable to oracle parameters

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...

6. Shell Programming and Scripting

Passing a value to stored procedure from unix shell script

Hi Dudes :) I want a unix shell script to pass value to SQL stored procedure. Below is the procedure declare res varchar2(10); begin odm_load_check('PRE_SANITY',res); dbms_output.put_line(res); end; select * from error_log; truncate table error_log; select * from test;

7. Shell Programming and Scripting

how to call oracle stored procedure from unix shell

Hi i want to call a oracle stored procedure from unix (using bash shell). consider this is my oracle stored procedure with parameter create procedure testproc(name IN varchar, age IN Number, id OUT Number ) AS begin id=1; dbms_output.put.line('successfull validation') end;...

8. Shell Programming and Scripting

passing variable to oracle procedure

using the script below I want to pass a parameters thorugh my sql call(@/unixsxxx/xxxx/helpenv.sql emptab ) as input into an oracle procedure xxxx_package.proc1(%1,emptab); . I tried %1 but it does not work. Any suggestions. #!bin/ksh set -x # export...

9. Shell Programming and Scripting

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...

10. UNIX for Dummies Questions & Answers

calling Oracle procedure from Unix

Does anyone know how to call an Oracle stored procedure from a Unix script?

LEARN ABOUT DEBIAN

make-sqldeveloper-package

MAKE-SQLDEVELOPER-PACKAGE(1)			    Oracle SQL Developer Debian package builder 		      MAKE-SQLDEVELOPER-PACKAGE(1)

NAME

       make-sqldeveloper-package - Oracle SQL Developer Debian package builder

SYNOPSIS

       make-sqldeveloper-package [options] <file>

DESCRIPTION

       make-sqldeveloper-package is a utility that builds a Debian package for Oracle SQL Developer.

       The  Oracle  SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with
       the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility
       to  use	the  resulting package acordingly with the OTN license, a copy of which is included in the created package, that you must agree on
       when downloading the source.

       This utility will require you to download the "Oracle SQL Developer  for  other	platforms"  archive  from  <http://www.oracle.com/technet-
       work/developer-tools/sql-developer/> to create the Debian package from.

OPTIONS

       -b|--build-dir <dir>
	      base directory to build package (autogenerated)

       -e|--email <email>
	      local maintainer email (use DEBEMAIL or auto-generate)

       -i|--install
	      install the generated package - needs root privilege (no)

       -k|--keep-dir
	      keep the build directory (no)

       -l|--revision <number>
	      local revision to append to package version (1)

       -m|--maintainer <name>
	      local maintainer name (use DEBFULLNAME or leave empty)

       -r|--root-command <command>
	      command to gain root privilege for package build (fakeroot)

       -u|--upstream-version <version>
	      force the upstream version (autodetected)

       -h|--help
	      display the help screen

       -v|--version
	      show the program version

       <file> the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technetwork/developer-tools/sql-developer/>

AUTHOR

       make-sqldeveloper-package was written by Lazarus Long <lazarus.long@bigfoot.com>.

       This manual page was written by Lazarus Long <lazarus.long@bigfoot.com>, for the Debian project (but may be used by others).

GNU
								    2012-11-13					      MAKE-SQLDEVELOPER-PACKAGE(1)

Shell Programming and Scripting