Re: How can I : Connect in SQL*Plus using defined variables

works fine as written

do you have SCAN set to ON (the default) or OFF? do you have DEFINE set to &? (the default)?

are the DEFINE values correct?

(i won't ask why you want to do this -- i'm sure you're aware of the security hole you're setting up here)

"Claus" <clkhm_at_hotmail.com> wrote in message news:3fa1332a$0$9809$edfadb0f_at_dread14.news.tele.dk...
> Hi there.
>
> In SQL*Plus I am trying to do the following
>
> DEFINE system_user_password = manager
> DEFINE connect_string = mydb
>
> connect system/&system_user_password_at_&connect_string
>
> Why are the variables in the line above not substituted and what should I
do
> to make it work.
>
> Thanks for your help.
>
> Claus
Received on Thu Oct 30 2003 - 17:21:25 CET