Re: ? Passing userid/password

From: Tommy Wareing <p0070621_at_oxford-brookes.ac.uk>
Date: 29 Jun 1993 03:54:29 -0500
Message-ID: <C9DKny.L4G_at_uk.ac.brookes>


thilde_at_mcdga2.cr.usgs.gov wrote:
> 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.

I've asked Oracle about this in the past, and they've told me it's not possible (this was under forms 2.3/Oracle 5). For security reasons, it shouldn't be possible anyway, otherwise anybody could write a form to extract usernames & passwords.
Have you considered converting the program to a user exit? That way, you don't need to log in again -- you have the same database login as is used by forms.

--
  _________________________   _________________________
 /  Tommy Wareing          \ /                         \
|  p0070621_at_uk.ac.brookes   X   'Bugger!' said Piglet   |
 \  0865-483389            / \                         /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Tue Jun 29 1993 - 10:54:29 CEST

Original text of this message