January 10, 2005, 02:02 PM
CHERIOracle 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
CHERIBecause this is our dev server I was looking at the wrong database. It's working no problems.
Thank You.