Hi all,
i have a trouble with settiong of environment for apache web server with php
and oracle8i database.
My connection to the database from php script thru OCI functions working but
my problem is, that
php script hasn't all environment variables from OS
(ORACLE_HOME,ORACLE_SID,NLS_LANG).
I hav
Define necessary env vars in Apache startup script.
putenv has no effect after httpd has started.
Good Luck,
-Stathis.
Martin Lustig wrote:
>
> Hi all,
>
> i have a trouble with settiong of environment for apache web server with php
> and oracle8i database.
> My connection to the database from
Hi Martin,
Try something along these lines ...
$query= "alter session set NLS_DATE_FORMAT = 'DD-MON-'";
$curs = ociparse($conn,$query) or die( "Unable to parse query" );
ociexecute($curs) or die( "Unable to execute query" );
You can also set this in you init.ora file i beleive
HTH
Ste