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

[Claus]

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@&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

[Harald Maier]

"Claus" <clkhm@hotmail.com> writes:
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@&connect_string Why are the variables in the line above not substituted and what should I do to make it work.


,----[ Test session ]
| SQL> define pwd=tiger
| SQL> define srv=first
| SQL> connect scott/&pwd@&srv;
| Connected.
| SQL>
`----

Works fine for me. What is your error message?
Harald

[mcstock]

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@hotmail.com> wrote in message
news:3fa1332a$0$9809$edfadb0f@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@&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

[Claus]

Hi all,

I was going crazy there for a second.

The reason was that the defines were done wrongly.

I had written

DEFINE system_user_password=manager

instead of

DEFINE system_user_password = manager

Big difference.

Yes I am aware of the security implications. Trust me, that is of no concern
in this case.

Thanks for your quick answers.

Regards
Claus