PowerHouse and Oracle on Solaris -- howto?

Ken Langendock ken.langendock at rogers.com
Fri May 8 09:23:10 CDT 2009


First off you should call tech support on this.

Here is my PDL definition from my application.

@if ORACLE
DATABASE SYDB &
  TYPE ORACLE &
  OWNER SY & ; Database User, cannot be a variable!!!
  NULL VALUES ALLOWED &
@if UNIX
  OPEN "ORACLE@$ORACLEDB@$ORACLE_SID/$ORDBPASS" &
@elseif WINDOWS
  OPEN "ORACLE@%ORACLEDB%@%ORACLE_SID%/%ORDBPASS%"
@endif

; Set consistency model to avoid Serialization problem.
TRANSACTION CONSISTENCY REPEATABLE READ
@endif


Assuming you have the proper variables set up before you start up PH, this
should work

Also on Windows, you have to have Oracle installed BEFORE you install
PH...not sure if this is true for UNIX.

Ken


Internal Virus Database is out-of-date.
Checked by AVG. 
Version: 7.5.557 / Virus Database: 270.12.11/2089 - Release Date: 30/04/2009
5:53 PM
 



More information about the powerh-l mailing list