How do i connect from one sqlplus connection to another sqlplus connection in a batch file like...(Extract of the batch file)
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.
Thanks & regards