Programming

#!/bin/sh
Name=$1;
export ORACLE_HOME

$ORACLE_HOME/bin/sqlplus scott@ORA/tiger <<EOF
spool /root/spool1.txt;
select * from tab where tname like '$Name%';
spool off;
EOF

echo "got query data"

exit;

import java.util.*;
import java.io.*;

public class Script {
	public static void main ( String[] s)
	{
		Runtime r= Runtime.getRuntime();//reference to runtime java environment
		Process P=null;
		String cmd2 = "/root/script.sh school";
		
		try {
			P=r.exec(cmd2);
	
			System.out.println(	P.waitFor());
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (InterruptedException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

#!/bin/sh
Name=$1;
export ORACLE_HOME

$ORACLE_HOME/bin/sqlplus scott@ORA/tiger <<EOF
spool /root/spool1.txt;
select * from tab where tname like '$Name%';
spool off;
EOF

LINECOUNT=`wc -l spool1.txt|cut -f1 d' '`

if [ $LINECOUNT -gt 0 ]
then
  exit 0 #SUCCESS
else
  exit 1 #FAIL
fi

   
try {
   P=r.exec(cmd2);
   String exitVal = P.exitValue();
}