Re: ? Passing userid/password

In <C9CnrG.I88_at_mcdgs01.cr.usgs.gov> thilde_at_mcdga2.cr.usgs.gov writes:
>Does anyone know how to pass the userid and password from a form to a C
>program that uses EXEC SQL statements? I am using the HOST command attached to the Key-print trigger in forms to execute the C program and I would rather not have to login again.

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.

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

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