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