Hi,

I need to hide the Oracle password accessed by sql script using the unix shell.
I mean to say when I do ps -aef|grep sqlplus, I see the sqlplus connection with userid/password displayed on the prompt.

My script looks something like below:
sqlplus -s $USERPASS << eoj >> $LOGFILE 2>&1
set serveroutput on size 1000000;
set head off feed on term off
DECLARE
TYPE t_del_cur IS REF CURSOR;
v_del_cur t_del_cur;

/* Variables */
v_err_code NUMBER;
v_err_text VARCHAR2(4000);
v_monthend_date VARCHAR2(4000):= NULL;
v_qry_stmt1 VARCHAR2(4000):= NULL;
v_month VARCHAR2(20);
v_sel_count BINARY_INTEGER := 0;

BEGIN

v_qry_stmt1 := NULL;
SELECT TO_CHAR(TO_DATE('$p_monthend_date','MM/DD/YYYY'),'DD-MON-YY')
INTO v_month
FROM DUAL;
DBMS_OUTPUT.PUT_LINE('Select Criteria :'||v_month);
EXCEPTION
WHEN OTHERS THEN
v_err_code := SQLCODE;
v_err_text := substr(SQLERRM,1,200);
DBMS_OUTPUT.PUT_LINE('SQL Error Code is: ' || v_err_code || ' Error message is ' || v_err_text );
END;
/
eoj

Let me know how do we accomplish to hide the password?

Thanks in advance,
AC