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 MOJAVE

mac::apps::launch

Launch(3)						User Contributed Perl Documentation						 Launch(3)

NAME

       Mac::Apps::Launch - Mac module to launch /quit applications

SYNOPSIS

	   use Mac::Apps::Launch;
	   my @apps = qw(R*ch Arch MPGP);
	   my $path = "HD:System Folder:Finder";
	   LaunchApps([@apps], 1) or warn $^E; # launch and switch to front
	   LaunchApps([@apps])	  or warn $^E; # launch and don't switch
	   LaunchApps($app, 1)	  or warn $^E; # launch and switch to front
	   LaunchSpecs($path, 1)  or warn $^E; # use path instead of app ID
	   QuitApps(@apps)	  or warn $^E; # quit all @apps
	   QuitAllApps(@apps)	  or warn $^E; # quit all except @apps
	   IsRunning('MACS');		       # returns boolean for whether
					       # given app ID is running
	   SetFront('MACS')	  or warn $^E; # set Finder to front
	   Hide('MACS') 	  or warn $^E; # hide Finder
	   Show('Finder', 1)	  or warn $^E; # show Finder (1 == use name)

DESCRIPTION

       Simply launch or quit applications by their creator ID.	The Finder can be quit in this way, though it cannot be launched in this way.

       This module is used by many other modules.

       This module as written does not work with MacPerls prior to 5.1.4r4.

       "Hide" and "Show" do not currently work on Mac OS X.

       Apps that don't have signatures under Mac OS X currently aren't handled, except with LaunchSpecs().

       "SetFront" and "IsRunning" can take a four-char creator ID ('MACS'), a bundle ID ('com.apple.Finder'), or a path
       (/System/Library/CoreServices/Finder.app).  They both optionally take a second parameter which affirms that the data is indeed a path (for
       those rare cases where a path might possibly look like a creator ID or bundle ID ... you never know).

       "IsRunning" will return the PSN of the application if it is running, which you can then use for targetting the app, or converting to a PID
       (with "Mac::Processes::GetProcessPID()"), to send signals to it.

EXPORT

       Exports functions "QuitApps", "QuitAllApps", and "LaunchApps", "IsRunning", "LaunchSpecs", "SetFront", "Hide", "Show".

AUTHOR

       Chris Nandor <pudge@pobox.com>, http://pudge.net/

       Copyright (c) 1999-2005 Chris Nandor.  All rights reserved.  This program is free software; you can redistribute it and/or modify it under
       the same terms as Perl itself.

perl v5.18.2							    2007-01-03								 Launch(3)

Shell Programming and Scripting