Help Needed while connection from one sqlplus to another in batch file


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_Process6_04_09get_env.sql
sqlplus invctl_doc/babel_3@dcs1d @P:61008Release_Management_Process6_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.

Please Help.

Thanks & regards

uday Bhole

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!