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
: 61008Release_Management_Process 6_04_09get_env.sql
sqlplus invctl_doc/babel_3@dcs1d @P
: 61008Release_Management_Process 6_04_09
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