Focal Point
Oracle Procedure in WF 5.3

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3941028331

January 10, 2005, 02:02 PM
CHERI
Oracle Procedure in WF 5.3
In WF 5.2 you were able to call an Oracle procedure using --
SQL SQLORA EX procedure_name;
We just installed WF 5.3 and it looks like now you must supply the database name, userid, and password like this --
SQL SQLORA SET USER databasename/user,password

has anyone experienced this ?
it seems supplying the password in the focexec would be an security issue
January 10, 2005, 02:20 PM
<WFUser>
If you set up your Oracle connection in the WebFOCUS Server Console, then all you will need to do is

SQL SQLORA SET SERVER servername
January 10, 2005, 03:19 PM
CHERI
Because this is our dev server I was looking at the wrong database. It's working no problems.
Thank You.