Shell Programming and Scripting

#!/bin/bash
 
        OUTPUT=$(isql -Usa -Ppassword -DNP_DB << EOF
        exec testing
        exit;
        EOF)
        echo output $OUTPUT
        echo last command status : $?
        if [ "$OUTPUT" != 0 ]
        then
            echo "error return from SP"
            exit
        else
            echo "SP return 0"
        fi

create proc testing
as
return 1

[tecnomen]##/export/home/xyz> ./callgSPFromScript_new.sh
output
last command status : 0
error return from SP
[tecnomen]##/export/home/xyz>

#!/bin/bash
`isql -Usa -Ppassword -DNP_DB << EOF
declare @returnValue int
exec @returnValue = testing
select ReturnValue=@returnValue
go
EOF`
echo $ReturnValue
echo last command status : $?
if [ "$OUTPUT" != 0 ]
then
echo "error return from SP"
exit
else
echo "SP return 0"
fi

create procedure testing 
returning integer; 
return 1; 
end;

create proc testing
as
return 1

#!/bin/bash
`isql -Usa -Ppassword -DNP_DB > file_return_value << EOF
declare @returnValue int
exec @returnValue = testing
select ReturnValue=@returnValue
print @returnValue
go
EOF`
echo $ReturnValue
echo last command status : $?
if [ "$OUTPUT" != 0 ]
then
echo "error return from SP"
exit
else
echo "SP return 0"
fi

CREATE OR REPLACE PROCEDURE test123(p_in NUMBER) IS
BEGIN

  IF p_in = 1 THEN
    raise_application_error(-20000, SQLERRM);
  END IF;

EXCEPTION
  WHEN OTHERS THEN
    raise_application_error(-20000, SQLERRM);
END;

. /var/opt/oracle/oravars9208
sqlplus -s "username/password@DBNAME" <<EOF
WHENEVER SQLERROR EXIT SQL.SQLCODE
--call the procedure
execute test123(p_in => 1);
exit
EOF
ret_cd=$?
if [ $ret_cd -eq  0 ]
then
echo "Successfully Executed"
else
echo "Error Occurred"
fi

[ctp-1-zone564:tecnomen] /export/home/tecnomen/> cat file_return_value
(return status = 1)
 ReturnValue
 -----------
           1
(1 row affected)
Msg 2737, Level 16, State 1:
Server 'SYBASE', Line 4:
Message passed to PRINT must be of type CHAR or VARCHAR.
[ctp-1-zone564:tecnomen] /export/home/tecnomen/>

variablename = `grep "return status" file_return_value | cut -d'=' -f2 | sed 's/\)//g'`