Kbase P125498: How to use oracle logins in a DataServer Oracle configuration
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/13/2008 |
|
Status: Unverified
GOAL:
How to use oracle logins in a DataServer Oracle configuration
GOAL:
How to connect Oracle via CONNECT statement
GOAL:
How to allow each user use their own logins when using Oracle DataServer configuration
FACT(s) (Environment):
All Supported Operating Systems
Progress 7.x
Progress 8.x
Progress 9.x
OpenEdge 10.x
Oracle DataServer
FIX:
Use CONNECT statement establish the connection to Oracle instead of connect Oracle via .pf (parameter file) or via command line.
By using CONNECT statement allows the developer to prompt the user to type in a valid login and password and use it as arguments for -U and -P parameter in the CONNECT statement.
The following is the CONNECT statement syntax:
CONNECT { { physical-name | VALUE ( expression ) } [ options ] | options } [ NO-ERROR ]
e.g: Supposed that your .pf looks like:
-db oholder -RO
-db oradb -dt ORACLE -ld orademo -S oserviceA -H doc4 -U scott -P tiger
by removing the second line of the pf and use the following ABL code, you should be able to establish the connection:
DEFINE VARIABLE cUser AS CHARACTER NO-UNDO.
DEFINE VARIABLE cPass AS CHARACTER NO-UNDO.
UPDATE cUser cPass.
CONNECT -db oradb -dt ORACLE -ld orademo -S oserviceA -H doc4 -U value(cUser) -P value(cPass)