The Oracle 7 functions require two environment variables to be set: ORACLE_HOME and
ORACLE_SID. They are most likely not set for your Web server, so you must use the
putenv function to set them. You will notice code to accomplish this in the examples
below.
Thies Arntzen, Stig Bakken, Mitch Golden, Andreas Karajannis, and Rasmus Lerdorf
contributed to the Oracle 7 extension. Oracle 8 support was added to PHP by Stig Bakken
and Thies Arntzen.
Table 13.9 lists constants created by the Oracle 8 Extension. When Oracle is installed, it
creates a test user. The login is scott and the password is tiger. I'll take advantage of
this in the examples below.
Table 13.9. All Oracle 8 Constants
OCI_ASSOC
OCI_BOTH
OCI_B_BFILE
OCI_B_BIN
OCI_B_BLOB
OCI_B_CFILEE
OCI_B_CLOB
OCI_B_CURSOR
OCI_B_ROWID
OCI_COMMIT_ON_SUCCESS
OCI_DEFAULT
OCI_DESCRIBE_ONLY
OCI_DTYPE_FILE
OCI_DTYPE_LOB
OCI_DTYPE_ROWID
OCI_D_FILE
OCI_D_LOB
OCI_D_ROWID
OCI_EXACT_FETCH
OCI_NUM
OCI_RETURN_LOBS
OCI_RETURN_NULLS
SQLT_BFILEE
SQLT_BLOB
SQLT_CFILEE
SQLT_CLOB
SQLT_RDD
boolean ocibindbyname (integer statement, string placeholder,
reference variable, integer length, integer type)