sqlplus -s XXXX/YYYY@$ABC_TOP/sql/new_oas_0069.sql
errorcode=$?
current_date_time=$?
#export LOG=$MISC/$current_date_time$SCRIPTNAME.log
export LOG=$MISC/$TEST$SCRIPTNAME.log

if [ $errorcode = 0 ]
then
echo 'new_oas_0069 has executed successfully'

WHENEVER SQLERROR EXIT 1

WHENEVER OSERROR EXIT 1

SET VERIFY OFF
SET HEADING OFF
SET FEEDBACK ON
SET TERMOUT ON
SET SERVEROUTPUT ON SIZE 25000
SET TIME ON

VARIABLE error_flag NUMBER;

VARIABLE current_date_time NVARCHAR2(100);

VARIABLE TEST NVARCHAR2(200);
BEGIN
:error_flag := 0;
:current_date_time:=null;
dbms_output.put_line(:error_flag);
test.AUTOMATION.new_oas_0069(:error_flag,:current_date_time);
dbms_output.put_line(:current_date_time);
END;
/