Using SQLNET 2 in Oracle Proc

Help,

when I use a single

exec sql connect :connectStrign where conenctString is username/passwd_at_ALIAS

things work fine.

NOTE: I Want to use SQLNET 2 so ALIAS Is a SQLNET 2 alias

Why doesn't

exec sql connect :username identified by :password

        at db_name1 using :database

where username = username
      password = password
      database = ALIAS

This doesn't work!

Any idea why? Received on Tue Nov 05 1996 - 00:00:00 CET