#! /bin/ksh
...
myscript # Call your script
RC=$? # Get your script's return status
HOST=$(uname -n)
# Call SQL*Plus
sqlplus username/password <<EOF
BEGIN
    INSERT INTO status_table VALUES('${HOST}', '${RC}');
    COMMIT;
END;
/
EOF

or
sqlplus username/password <<EOF
BEGIN
    your_plsql_sp('${HOST}', '${RC}');
END;
/
EOF

#! /bin/ksh
...
# Loop forever
while :
do
    {
        sqlplus -S username/password <<EOF
set heading off feedback off serveroutput on
DECLARE
    STATUS_CODE VARCHAR2(50) := 'none';
BEGIN
    -- Attempt to find the status for the specified host
    SELECT 'StatusCode:' || 0
    INTO    STATUS_CODE
    FROM   status_table
    WHERE  hostname = '${HOST}';

    -- Found it, print the status and drop out of PL/SQL block
    DBMS_OUTPUT.PUT_LINE (STATUS_CODE);

EXCEPTION
    -- No status yet, drop out with a -1 code
    WHEN NO_DATA_FOUND THEN
        SELECT 'StatusCode:-1'
        INTO   STATUS_CODE
        FROM   dual;

        DBMS_OUTPUT.PUT_LINE (STATUS_CODE);
END;
/
EOF
    } | while read LINE # Find out what SQL*Plus says
    do
        # Look for the status message
        if print $LINE | /usr/xpg4/bin/grep -iq StatusCode
        then
            # Parse out the actual status code and break from inner loop
            STATUS_CODE=$(print $LINE | awk -F: '{print $2}')
            break
        fi
    done

    # If status code is not -1, break out of endless loop
    if [ ${STATUS_CODE:=-1} -ge 0 ]
    then
        break
    fi
    # Otherwise, continue monitoring the status table
    print "Still waiting for status..."
    sleep 5
done

if [ ${STATUS_CODE} -eq 0 ]
then
    maix -s Success...
else
    maix -s Sorry, it failed...
fi