return code from oracle to unix script Post: 302378544

10 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

Store return code of shell script in oracle table

Hi friends, I have to do the following things : 1) there should be a shell script returning the returning the return code of the script. and i have to add some more details like on which machine is has run , at what time and other details and then using plsql i have to add a row to Oracle...

3. Shell Programming and Scripting

how to return an array of elements from oracle to shell script

Hi all, I have a interresting problem. My application is as follows: From a shell script i will conn to a oracle database and fetch few rows using a select statement. Then i want to sort these rows and return a column (collection of values of a column from the selected results) as array...

4. Shell Programming and Scripting

Capture Oracle return code in shell script

I am using the following code in my shell script list=`sqlplus -s $user/$pwd@$dbms<<EOF WHENEVER SQLERROR EXIT SQL.SQLCODE set pagesize 0 feedback off verify off heading off echo off select * from control_tbl where src_nm=$3 and extrct_nm=$4; exit SQL.SQLCODE; EOF` ERROR=$?...

5. Shell Programming and Scripting

return code of a unix command

How to find out whether the command I executed is successful or unsuccessful(at commandlinet) Eg: say i execute the following command at command line rm * How do i find out whether my previous command is a success or failure. Thankyou. Best Regards, Ram.

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

7. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the...

8. Shell Programming and Scripting

Writing a UNIX script from LOG to provide return code.

Folks - Firstly, I do apologize that my first post here is a question. I am quite familiar with UNIX since our application is running on it. We are trying to automate a few things on our end and I am challenged with a task in hand that requires UNIX scripting. I am totally a newbie in UNIX...

9. Shell Programming and Scripting

Unix return code example

Hi, Does anyone here can guide me to understand how is return code works in a parent-child relation with a simple example? I have a request to build the script with return code in a child script, but i want to understand how does child script can return a code to the parent, stated if its...

10. Shell Programming and Scripting

Need to get return code from mutt if an address is invalid/undeliverable from Unix shell script

I am using mutt on ksh Unix to send emails to addresses plucked from the database. If the "To:" email address is not longer valid and so the email is not sent to the "To:" recipient, but is sent to the valid cc address, I need to be able to get an error code returned to the shell script so that...

LEARN ABOUT DEBIAN

socklog-check

socklog-check(8)					      System Manager's Manual						  socklog-check(8)

NAME

       socklog-check - checks for the availability of a socklog(8) service.

SYNOPSIS

       socklog-check [-v] [unix [address]]

DESCRIPTION

       socklog-check attempts to connect to a socklog(8) unix service and reports whether the connection attempt succeeded or not.

       It connects to the datagram oriented unix domain socket address, and reports success through the return code.  If address is not specified,
       socklog-check attempts to connect to /dev/log.

       When running services that use the syslog facility under runit's service supervision, socklog-check should be added to the top of the  ser-
       vice's run script to ensure that no syslog messages are generated until a syslog service is up and running to process the messages, e.g.:

	#!/bin/sh
	socklog-check || exit 1
	exec service_using_syslog

OPTIONS

       -v     verbose.	Print verbose message to standard error.

EXIT CODES

       On success socklog-check returns 0.

       On error, socklog-check prints a message to standard error and exits 111.

SEE ALSO

       socklog(8), socklog-conf(8), svlogd(8), tryto(1), uncat(1), sv(8), runsv(8), runsvdir(8)

	http://smarden.org/socklog/
	http://smarden.org/runit/

AUTHOR

       Gerrit Pape <pape@smarden.org>

																  socklog-check(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting