09-28-2009
you have a few choices:
1) eval spool1.txt in the shell script and return a value based on the result, then check the value in java
2) do step one entirely in java by reading in spool1.txt
3) if you don't actually need your spool.txt for later processing, you could instead nest your query in case statement and return the success/fail as different conditions. you still have to eval the result though.
4) used jdbc to connect to your system and do it all in java.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
sample code as following:
test_sql(){
#test#echo test_sql
str=`$ORACLE_BIN/sqlplus -s $user/$passwd <<EOM
set verify off
set heading off
set feedback off
#--------start pl/sql
{
DECLARE
CURSOR pah_cs IS
select id from table
where letter = 'abcd';... (6 Replies)
Discussion started by: YoYo
6 Replies
2. UNIX for Dummies Questions & Answers
I like to call a shell script from pl/sql proceduere and i have to use the shell script return value in that procedure. i am using oracle 9i and cygwin.
can any one suggest me how can i do this (0 Replies)
Discussion started by: rajesh.P
0 Replies
3. Shell Programming and Scripting
I would like to call the shell script from pl/sql and i need to uses the value returned by the shell script in pl/sql procedure.
can any one suggest me how can i do that? (3 Replies)
Discussion started by: rajesh.P
3 Replies
4. Solaris
Hello.
I was trying to installe oracle 10g on solaris t0 x86 and got few exception? Could you please suggest, what might be going wrong?
$ ls -l
total 32
drwxr-xr-x 9 oracle dba 512 Nov 21 03:50 doc
drwxr-xr-x 5 oracle dba 512 Nov 21 03:50 install
drwxr-xr-x 2... (5 Replies)
Discussion started by: panchpan
5 Replies
5. Solaris
I have a simple makefile which I use to sync libraries files from /source/sybase directory on the source machine where the Makefile resides to /destination/folder on the various destination machines like machine1, machine2, machine3 using solaris utility 'rsync'. So when I run "make -f makefilename... (7 Replies)
Discussion started by: waavman
7 Replies
6. Shell Programming and Scripting
Hi All,
I am new to shell script, just wanted you guy to help.
How do i call a java program by using shell script, pls give some samle code for it,
thank you ver much. (2 Replies)
Discussion started by: aaabbb123123
2 Replies
7. UNIX for Advanced & Expert Users
Hi,
I call a java program from a cron job and i need to display the exceptions or Errors thrown by java(basically stacktrace) in the unix/linux console in the red color.Is it possible to do that? If so, pls. give me some pointers how to do that.
eg:
Exception in thread "main"... (0 Replies)
Discussion started by: ramse8pc
0 Replies
8. UNIX for Advanced & Expert Users
Hi i am not able to connect sqlplus
my script is as follows
$ORACLE_HOME/bin/sqlplus << ! > /tmp/extract/DM.txt
and output is
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Jan 18 02:53:54 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter user-name: t175481... (1 Reply)
Discussion started by: tushar_spatil
1 Replies
9. UNIX for Dummies Questions & Answers
I want to call the sql query from UNIX..but how to set page size and other necessary parameters i don't know plz guide me how to do this (2 Replies)
Discussion started by: sagar_1986
2 Replies
10. Shell Programming and Scripting
I'm using getopts to process command line args in a Bash script. The code looks like this:
while getopts ":cfmvhs:t:" option; do
case $option in
c) operationMode="CHECK"
;;
f) operationMode="FAST"
;;
m) ... (6 Replies)
Discussion started by: gencon
6 Replies
LEARN ABOUT LINUX
git-check-attr
GIT-CHECK-ATTR(1) Git Manual GIT-CHECK-ATTR(1)
NAME
git-check-attr - Display gitattributes information
SYNOPSIS
git check-attr [-a | --all | attr...] [--] pathname...
git check-attr --stdin [-z] [-a | --all | attr...] < <list-of-paths>
DESCRIPTION
For every pathname, this command will list if each attribute is unspecified, set, or unset as a gitattribute on that pathname.
OPTIONS
-a, --all
List all attributes that are associated with the specified paths. If this option is used, then unspecified attributes will not be
included in the output.
--cached
Consider .gitattributes in the index only, ignoring the working tree.
--stdin
Read file names from stdin instead of from the command-line.
-z
The output format is modified to be machine-parseable. If --stdin is also given, input paths are separated with a NUL character instead
of a linefeed character.
--
Interpret all preceding arguments as attributes and all following arguments as path names.
If none of --stdin, --all, or -- is used, the first argument will be treated as an attribute and the rest of the arguments as pathnames.
OUTPUT
The output is of the form: <path> COLON SP <attribute> COLON SP <info> LF
unless -z is in effect, in which case NUL is used as delimiter: <path> NUL <attribute> NUL <info> NUL
<path> is the path of a file being queried, <attribute> is an attribute being queried and <info> can be either:
unspecified
when the attribute is not defined for the path.
unset
when the attribute is defined as false.
set
when the attribute is defined as true.
<value>
when a value has been assigned to the attribute.
Buffering happens as documented under the GIT_FLUSH option in git(1). The caller is responsible for avoiding deadlocks caused by
overfilling an input buffer or reading from an empty output buffer.
EXAMPLES
In the examples, the following .gitattributes file is used:
*.java diff=java -crlf myAttr
NoMyAttr.java !myAttr
README caveat=unspecified
o Listing a single attribute:
$ git check-attr diff org/example/MyClass.java
org/example/MyClass.java: diff: java
o Listing multiple attributes for a file:
$ git check-attr crlf diff myAttr -- org/example/MyClass.java
org/example/MyClass.java: crlf: unset
org/example/MyClass.java: diff: java
org/example/MyClass.java: myAttr: set
o Listing all attributes for a file:
$ git check-attr --all -- org/example/MyClass.java
org/example/MyClass.java: diff: java
org/example/MyClass.java: myAttr: set
o Listing an attribute for multiple files:
$ git check-attr myAttr -- org/example/MyClass.java org/example/NoMyAttr.java
org/example/MyClass.java: myAttr: set
org/example/NoMyAttr.java: myAttr: unspecified
o Not all values are equally unambiguous:
$ git check-attr caveat README
README: caveat: unspecified
SEE ALSO
gitattributes(5).
GIT
Part of the git(1) suite
Git 1.8.5.3 01/14/2014 GIT-CHECK-ATTR(1)