Re: Getting Username, Password and Oracle instance name.

[Franck Masson <franck.masson@BRIO.COM>]

Christian,

1) USERNAME
The variable $username is the database user name specified on the
command line.

$username is an SQR reserved, or predefined, variable.
All of SQR's reserved variables are global variables. Within a local
procedure they must be referenced using the leading underscore:
$_username.

2) For the Other
Password and instance
i have not the info but may be you can ask to your DBA how to get the
instance.

and other solution is to modify the syntaxe of the sqr command and
replace the existing sqr that do the same plus set a variable with the
connection information
connect=PDupont/cmy45xq@ora_orcl
export connect
sqr toto.sqr $connect


franck,

Christian ARNAUD wrote:
>
> Is there a mean from within a SQR report to get the user name, the password
> et the Instance name of the current database we are logging on?
>
> In other words, is there a mean to get the command line parameter discribing
> this informations (i.e. PDupont/cmy45xq@ora_orcl)?
>
> Thank you for your help.
begin:          vcard
fn:             Franck Masson
n:              ;Franck Masson
adr;dom:        Le capitol;;55 av. des champs Pierreux;Nanterre;92000;;
email;internet: franck.masson@brio.com
tel;work:       33 1 55 69 36 00
tel;fax:        33 1 47 25 02 59
tel;home:       Mobile : 33 6 84 80 17 05
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard