SQLPLUS Windows XP batch file logon validation

[guylav]

Hi,
I try to validate my logon in a batch file.

@echo off
set /P User=User DB :
set /P Passwd=Pass WD DB :
C:\oracle\ora81\bin\SQLPLUSW.EXE -S
%User%/%Passwd%@GPRU2 @U:\tmp\go_travel.sql

If is not a good logon what can I do ? SQLPLUS open an stop there,,,,,

 

[Marco Kalter]

You are trying to do something similar for PL/SQL Developer? That would be the following:

@echo off
set /P User=User DB :
set /P Passwd=Pass WD DB :
"C:\Program Files\PLSQL Developer\plsqldev.exe" userid=%User%/%Passwd%@GPRU2 commandfile=U:\tmp\go_travel.sql