Re: ? Passing userid/password

In article <SSOMsATMBh107h_at_uidixon.uucp> uidixon!idixon_at_infocom.co.uk writes:

>The problem is that password is not directly available from Forms but,
>as long as the form is called from SQL*Menu, that can be solved. In Menu,
>assign the menu variable PW to a global variable before calling the form.
>In the form, name the global variable when calling the C program.

Clever! Presumably the SQL*Menu command line is something like ORALOGIN=&UN/&PW export ORALOGIN ; runform foo &UN/&PW

And then in the C program run from the form using #HOST get the login by using getenv("ORALOGIN").

>You'll need to be careful to make sure that the global variable gets
>erased.

Following might solve that:
ORALOGIN=&UN/&PW runform foo &UN/&PW

                ^
                NB: No semi-colon.

>I've used this technique to run most of the Oracle utilities as well as C
>programs.
>
>Hope this helps
>
>Ian
>
>--
>Ian Dixon Email : idixon_at_infocom.co.uk
>Reading, England
>
 

-- 

Paul Beardsell                          21 Finn House, Bevenden St, HOXTON,
~~~~~~~~~~~~~~                          Hackney, London, N1-6BN, UK.
paul_at_hoxton.demon.co.uk
pbeardsell_at_cix.compulink.co.uk          (+44 or 0)71 608-2391