perhaps you might want to consider sourcing .profile before running sqlplus. Raj On 8/11/05, Jared Still <jkstill@xxxxxxxxx> wrote: > > Even better! > > On 8/11/05, Magnus Andersen <mag.andersen@xxxxxxxxx> wrote: > > > > I use the -s in my scripts in combo with a here doc. > > > > su - oracle -c $ORACLE_HOME/bin/sqlplus -s <<! > > / as sysdba > > @/apps/oracle/select_user.sql > > disconnect > > ! > > > > -- > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist > > -- ------------------------------ select standard_disclaimer from company_requirements where category = 'MANDATORY';