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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
