Hi,

How do i connect from one sqlplus connection to another sqlplus connection in a batch file like...(Extract of the batch file)

:RICDB
sqlplus cfgcent/cfgcent_3@dcs1d @P:\061008\Release_Management_Process\06_04_09\get_env.sql
sqlplus invctl_doc/babel_3@dcs1d @P:\061008\Release_Management_Process\06_04_09\run.sql

my problem is after connecting to one env (schema) it does not go to another.

Also is there any way i can store the output of the sql statement into batch variable.

Please Help.

Thanks & regards

uday Bhole