Thank you Mr.David, I have changed a bit & used it like this.
set user=%1 set pass=%2 set Tnsname=%3 sqlplus %user%/%pa...@%tnsname% On Fri, Aug 14, 2009 at 12:58 AM, ddf <[email protected]> wrote: > > > > On Aug 13, 1:45 pm, ddf <[email protected]> wrote: > > On Aug 13, 11:24 am, Karthikeyan R <[email protected]> wrote: > > > > > Hi, > > > > > I need to write a batch file which would accept parameters & then > > > login to Oracle and then I need to run a sql file (for ex: test.sql) > > > > > I used to connect it by using the following text > > > sqlplus username/passw...@sid @test.sql > > > > > But I have to get username, password & sid as parameters in the command > prompt. > > > > > can someone help me out in doing this?. > > > > > -- > > > Thanks & Regards, > > > Karthikeyan > > > > connect.bat: > > > > sqlplus %%1/%...@%%3 > > > > Add whatever script you want at the end of that line. > > > > David Fitzjarrell > > I have too many % in that command; the correct syntax is: > > sqlplus %1/%...@%3 > > My apologies. > > > David Fitzjarrell > > > -- Thanks & Regards, Karthikeyan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
