Hi

I have a shell function which returns string(ksh). The string is an sql statement.
This statement can have '*' in its content (i.e. select 100 / 2 *100 from dual).
When this happens ret_str will have contents of current directry I run the script from build in sql. Is there any way to fix it ?

ret_str=Get_Sql $PID
echo $ret_str

Get_Sql()
{
Set_Ora_Sid $DBNAME

sqlplus -s '/as sysdba' 2>&1 <<EOF
...
...
select :v_sql_txt from dual;
EOF
}

Thanks you