Get Oracle fuction return value in a variable Post: 69369

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

return code from oracle

I am writing a unix script that logs into oracle and does a count on a table. I want to return that count to my unix script. this is my script: #!/bin/ksh typeset retcode; numin=0 sqlplus -s <<-EOSQL myuser/mypass@mydb variable ret_val number; begin ...

2. Shell Programming and Scripting

ORACLE return a function to Solaris

Guys, I�m have this problem and I do not know what to do anymore: cod=`sqlplus -s ${DATABASE} << EOF set heading off feedback off verify off select max(eventid) from events; exit EOF` sed "s/CODEVENTID/${cod}/" c.ctl Abova What I�ve done. The CODEEVENTID is already set into a...

3. Shell Programming and Scripting

fuction return in perl

Hi All, I have a perl script(1.pl) that calls a c function defined in another file sample.c #!/usr/bin/perl my $re = 1; my @s = `/home/PERL_SCRIPTING/Rough/sample pline $re 10`; print "$_" foreach(@s); The sample.c is as bwlow: # include <stdio.h> int pline(int, int);...

4. UNIX for Dummies Questions & Answers

Return value from oracle to unix shell

Hi , i have written a shell scipt to call a procedure and get the value back from procedure.But i am facing the issue like #!/bin/sh returnedvalue=`sqlplus -s userid/pass<<EOF set serveroutput on; exec pass($1) set serveroutput off; EXIT; EOF` flag=`echo $returnedvalue ` echo "$flag"...

5. Shell Programming and Scripting

Return rows from Oracle package

I need help . I am not getting anything back from my setup. I have defined an oracle package which I am calling from within my sql call, but is returning no rows. If I run my sql from sqlplus works find, does not work whe I try to run from UNIX shell script My korn script test.ksh #!bin/ksh...

6. Shell Programming and Scripting

Insert a line including Variable & Carriage Return / sed command as Variable

I want to instert Category:XXXXX into the 2. line something like this should work, but I have somewhere the wrong sytanx. something with the linebreak goes wrong: sed "2i\\${n}Category:$cat\n" Sample: Titel Blahh Blahh abllk sdhsd sjdhf Blahh Blah Blahh Blahh Should look like...

7. UNIX and Linux Applications

Oracle return codes?

Having searched high and low through Oracles documentation, I came to think that they're very scripting-averse, as there's (apparently) no list of possible return/exit codes for their various command line utilities. Is anyone here in possession of such a list, or knows where to find one? It...

8. Shell Programming and Scripting

getting return value from oracle function

So, in Oracle (11gR2) on aix I have a function like: CREATE OR REPLACE function COMMON.t2(var1 in varchar2, vari in number,var2 in out number) return number as begin insert into korisnik_temp(kor_inicia, kor_opisno) values(1, var1); var2:=0; return var2; exception when...

9. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL...

LEARN ABOUT DEBIAN

myproxy-admin-change-pass

myproxy-admin-change-pass(8)					      MyProxy					      myproxy-admin-change-pass(8)

NAME

       myproxy-admin-change-pass - change credential passphrase

SYNOPSIS

       myproxy-admin-change-pass [ options ]

DESCRIPTION

       The  myproxy-admin-change-pass  command	changes  the passphrase used to encrypt a credential in the MyProxy repository.  The command first
       prompts for the current passphrase for the credential, then prompts twice for the new passphrase.  If an empty  passphrase  is  given,  the
       credential  will  not  be  encrypted.   It  accesses  the repository directly and must be run on the machine where the myproxy-server(8) is
       installed from the account that owns the repository.

OPTIONS

       -h     Displays command usage text and exits.

       -u     Displays command usage text and exits.

       -s dir Specifies the location of the credential storage directory.  The directory must be accessible only by the user running the  myproxy-
	      server process for security reasons.  Default: /var/lib/myproxy or /var/myproxy or $GLOBUS_LOCATION/var/myproxy

       -l username
	      Specifies the MyProxy account under which the credential should be stored.

       -k name
	      Specifies the credential name.

       -S, --stdin_pass
	      By  default, the command prompts for a passphrase and reads the passphrase from the active tty.  When running the command non-inter-
	      actively, there may be no associated tty.  Specifying this option tells the command to read passphrases from standard input  without
	      prompts or confirmation.

EXIT STATUS

       0 on success, >0 on error

AUTHORS

       See http://myproxy.ncsa.uiuc.edu/about for the list of MyProxy authors.

SEE ALSO

       myproxy-change-pass-phrase(1),	myproxy-destroy(1),  myproxy-info(1),  myproxy-init(1),  myproxy-logon(1),  myproxy-retrieve(1),  myproxy-
       store(1), myproxy-server.config(5), myproxy-admin-adduser(8), myproxy-admin-load-credential(8), myproxy-admin-query(8), myproxy-server(8)

MyProxy 							     2009-12-1					      myproxy-admin-change-pass(8)