re: setting sqlplus prompt

[hreddy007]

hi! Guys,

I have Oracle 8.1.5 server and client running on a computer
with windows 2000 professional operating system.

I created a file login.sql in which I set the sql_prompt...

But when I login through sqlplus the sql prompt remains SQL>

What could be the problem and how do I change the sqlprompt ???

thanks for your insights and help ..

harish

[DaPi]

Put the following as connect.sql in your /bin directory and connect in sqlplus with @connect instead of connect. (Full aknowledgements to Tom Kyte).

connect &1
set termout off
@login
set termout on

[hreddy007]

still not working ??

what am i missing ..

do i need to put the login.sql in any particular place ?

[DaPi]

Easiest to have both login.sql & connect.sql in the /bin directory on the client.

[hreddy007]

works now !!!

thanks a lot dapi ..

[pando]

you can use SQL_PATH env variable to set directories where your scripts are stored.