oracle mystery

[hegyvari@ardents.hu]

Hi,

I have a few apps written in PHP, running on Fedora Core. After porting
these applications from PostgreSQL to Oracle a bug appeared: sometimes,
not in a reproducable manner, the web page does not appear in the
browser and after examining the html source in the browser I notice
that the code is cut in half, somewhere after about the first 3-4
kbytes.

It happens quite often, once in every two minutes. The problem was not
there when I used PostgreSQL. PHP is compiled from source against the
Oracle 10 client downloaded from technet.

Any ideas why this happens?

Regards,

Hegyvari Krisztian

ps: I tried to migrate to the integrated zend instant client solution,
but then the letters with accents ceased to appear. Instant client does
not use nls_lang, which was set to american_americ a.ee8iso8859p2. I
would really appreciate any ideas how to get my special letters appear
again with instant client.

[Richard Levasseur]

Re: oracle mystery

I remember in a class i had we needed to connect to an oracle server in
PHP and seemingly randomly the pages would just die. Nothing would
load, view source would be truncated or empty, database queries would
fail without reason.

I don't know exactly what the cause was but:
1) When pages die unexpectedly, check the apache log for segfault
messages. Occasionally a coding mishap creates an recursive loop or
something, which results in a segfault and you just get pieces of a
page with no error on the browser end
2) switching from the oci_* functions to the ora_* functions seemed to
fix the oracle connection problems in class. Our instructor said it
may have been due to a maximum number of logins being reached (we had
the whole class logging in under the same anon account).

I'm not familar with using non-ascii charsets, really, so I can't be of
much help there. Maybe just check to see if everything along the way
(php, 3rd party libs, etc..) is capable of using the character set and
those special accented characters?

Hope this helps

-Richard Levasseur

[Mladen Gogala]

Re: oracle mystery

On Thu, 20 Apr 2006 09:56:00 -0700, hegyvari wrote:
[color=blue]
> It happens quite often, once in every two minutes. The problem was not
> there when I used PostgreSQL. PHP is compiled from source against the
> Oracle 10 client downloaded from technet.[/color]

You should take a look at web server logfile and see what error are you
getting. Also, check Oracle instance alert.log file and see if you're
getting any ORA-00600 ora ORA-07445 errors which would cause Oracle server
process to freeze.
[color=blue]
>
> Any ideas why this happens?
>
> Regards,
>
> Hegyvari Krisztian
>
> ps: I tried to migrate to the integrated zend instant client solution,
> but then the letters with accents ceased to appear. Instant client does
> not use nls_lang, which was set to american_americ a.ee8iso8859p2. I
> would really appreciate any ideas how to get my special letters appear
> again with instant client.[/color]

US English with middle-European character set? A novel idea, if I ever saw
one. George Mikes would love you for that. As far as the instant client
goes, it is just like fast food: it kills you if you use it too often.
You're much better off with a full-fledged Oracle client.

--

http://www.mgogala.com

[hegyvari@ardents.hu]

Re: oracle mystery

This setting was recommended to me by Oracle a few years ago. As I have
written I have nothing against the full client, wish my pages would not
die when using it.

[Mladen Gogala]

Re: oracle mystery

On Fri, 21 Apr 2006 07:06:32 -0700, hegyvari wrote:
[color=blue]
> This setting was recommended to me by Oracle a few years ago. As I have
> written I have nothing against the full client, wish my pages would not
> die when using it.[/color]

I have no problems whatsoever. Here is my SW combination:


$ rpm -qa|egrep "^kernel|^h ttpd-"|sort
httpd-2.0.54-10.3
httpd-devel-2.0.54-10.3
kernel-2.6.16-1.2069_FC4
kernel-devel-2.6.16-1.2069_FC4
$
$ sqlplus scott/tiger

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Apr 21 20:59:48 2006

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

phpinfo()
PHP Version => 5.1.2

System => Linux medo.noip.com 2.6.16-1.2069_FC4 #1 Tue Mar 28 12:19:10 EST 2006 i686
Build Date => Mar 31 2006 08:34:49
Configure Command => './configure' '--with-apxs2=/usr/sbin/apxs' '--with-xmlrpc' '--with-zlib' '--with-bz2' '--with-ttf' '--with-gd' '--enable-gd-native-ttf' '--with-freetype-dir' '--with-jpeg-dir' '--with-png-dir' '--with-config-file-path=/usr/local/lib/php' '--enable-sigchild' '--without-sqlite' '--disable-mysql' '--disable-pdo'
Server API => Command Line Interface
Virtual Directory Support => disabled
Configuration File (php.ini) Path => /usr/local/lib/php/php.ini
PHP API => 20041225
PHP Extension => 20050922
Zend Extension => 220051025
Debug Build => no
Thread Safety => disabled
Zend Memory Manager => enabled
IPv6 Support => enabled
Registered PHP Streams => php, file, http, ftp, compress.bzip2, compress.zlib
Registered Stream Socket Transports => tcp, udp, unix, udg
Registered Stream Filters => string.rot13, string.toupper, string.tolower, string.strip_ta gs, convert.*, convert.iconv.* , bzip2.*, zlib.*


This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies


_______________ _______________ _______________ _______________ ___________


Configuration

PHP Core

Directive => Local Value => Master Value
allow_call_time _pass_reference => Off => Off
allow_url_fopen => On => On
always_populate _raw_post_data => Off => Off
arg_separator.i nput => & => &
arg_separator.o utput => & => &
asp_tags => Off => Off
auto_append_fil e => no value => no value
auto_globals_ji t => On => On
auto_prepend_fi le => no value => no value
browscap => no value => no value
default_charset => no value => no value
default_mimetyp e => text/html => text/html
define_syslog_v ariables => Off => Off
disable_classes => no value => no value
disable_functio ns => no value => no value
display_errors => Off => Off
display_startup _errors => Off => Off
doc_root => no value => no value
docref_ext => no value => no value
docref_root => no value => no value
enable_dl => On => On
error_append_st ring => no value => no value
error_log => no value => no value
error_prepend_s tring => no value => no value
error_reporting => 2047 => 2047
expose_php => On => On
extension_dir => /usr/local/lib/php/extensions/no-debug-non-zts-20050922 => /usr/local/lib/php/extensions/no-debug-non-zts-20050922
file_uploads => On => On
highlight.bg => #FFFFFF => #FFFFFF
highlight.comme nt => #FF8000 => #FF8000
highlight.defau lt => #0000BB => #0000BB
highlight.html => #000000 => #000000
highlight.keywo rd => #007700 => #007700
highlight.strin g => #DD0000 => #DD0000
html_errors => Off => On
ignore_repeated _errors => Off => Off
ignore_repeated _source => Off => Off
ignore_user_abo rt => Off => Off
implicit_flush => On => Off
include_path => .:/usr/local/lib/php:/usr/local/PHP => .:/usr/local/lib/php:/usr/local/PHP
log_errors => On => On
log_errors_max_ len => 1024 => 1024
magic_quotes_gp c => Off => Off
magic_quotes_ru ntime => Off => Off
magic_quotes_sy base => Off => Off
mail.force_extr a_parameters => no value => no value
max_execution_t ime => 0 => 30
max_input_time => 60 => 60
open_basedir => no value => no value
output_bufferin g => 0 => 4096
output_handler => no value => no value
post_max_size => 8M => 8M
precision => 14 => 14
realpath_cache_ size => 16K => 16K
realpath_cache_ ttl => 120 => 120
register_argc_a rgv => On => Off
register_global s => Off => Off
register_long_a rrays => Off => Off
report_memleaks => On => On
report_zend_deb ug => Off => Off
safe_mode => Off => Off
safe_mode_exec_ dir => no value => no value
safe_mode_gid => Off => Off
safe_mode_inclu de_dir => no value => no value
sendmail_from => no value => no value
sendmail_path => /usr/sbin/sendmail -t -i => /usr/sbin/sendmail -t -i
serialize_preci sion => 100 => 100
short_open_tag => On => On
SMTP => localhost => localhost
smtp_port => 25 => 25
sql.safe_mode => Off => Off
track_errors => Off => Off
unserialize_cal lback_func => no value => no value
upload_max_file size => 2M => 2M
upload_tmp_dir => no value => no value
user_dir => no value => no value
variables_order => GPCS => GPCS
xmlrpc_error_nu mber => 0 => 0
xmlrpc_errors => Off => Off
y2k_compliance => On => On
zend.ze1_compat ibility_mode => Off => Off

bz2

BZip2 Support => Enabled
Stream Wrapper support => compress.bz2://
Stream Filter support => bzip2.decompres s, bzip2.compress
BZip2 Version => 1.0.2, 30-Dec-2001

ctype

ctype functions => enabled

date

date/time support => enabled
Timezone Database Version => 2005.18
Timezone Database => internal
Default timezone => America/New_York

Directive => Local Value => Master Value
date.default_la titude => 31.7667 => 31.7667
date.default_lo ngitude => 35.2333 => 35.2333
date.sunrise_ze nith => 90.583333 => 90.583333
date.sunset_zen ith => 90.583333 => 90.583333
date.timezone => no value => no value

dom

DOM/XML => enabled
DOM/XML API Version => 20031129
libxml Version => 2.6.20
HTML Support => enabled
XPath Support => enabled
XPointer Support => enabled
Schema Support => enabled
RelaxNG Support => enabled

gd

GD Support => enabled
GD Version => bundled (2.0.28 compatible)
FreeType Support => enabled
FreeType Linkage => with freetype
FreeType Version => 2.1.9
GIF Read Support => enabled
GIF Create Support => enabled
JPG Support => enabled
PNG Support => enabled
WBMP Support => enabled
XBM Support => enabled

hash

hash support => enabled
Hashing Engines => md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

iconv

iconv support => enabled
iconv implementation => glibc
iconv library version => 2.3.6

Directive => Local Value => Master Value
iconv.input_enc oding => ISO-8859-1 => ISO-8859-1
iconv.internal_ encoding => ISO-8859-1 => ISO-8859-1
iconv.output_en coding => ISO-8859-1 => ISO-8859-1

libxml

libXML support => active
libXML Version => 2.6.20
libXML streams => enabled

oci8

OCI8 Support => enabled
Revision => $Revision: 1.293 $
Active Persistent Connections => 0
Active Connections => 0
Oracle Version =>
Compile-time ORACLE_HOME =>
Libraries Used =>
Temporary Lob support => enabled
Collections support => enabled

Directive => Local Value => Master Value
oci8.default_pr efetch => 10 => 10
oci8.max_persis tent => -1 => -1
oci8.old_oci_cl ose_semantics => 0 => 0
oci8.persistent _timeout => -1 => -1
oci8.ping_inter val => 60 => 60
oci8.privileged _connect => Off => Off
oci8.statement_ cache_size => 20 => 20

pcre

PCRE (Perl Compatible Regular Expressions) Support => enabled
PCRE Library Version => 6.2 01-Aug-2005

posix

Revision => $Revision: 1.70.2.3 $

Reflection

Reflection => enabled
Version => $Id: php_reflection. c,v 1.164.2.17 2006/01/01 12:50:12 sniper Exp $

session

Session Support => enabled
Registered save handlers => files user
Registered serializer handlers => php php_binary

Directive => Local Value => Master Value
session.auto_st art => Off => Off
session.bug_com pat_42 => Off => Off
session.bug_com pat_warn => On => On
session.cache_e xpire => 180 => 180
session.cache_l imiter => nocache => nocache
session.cookie_ domain => no value => no value
session.cookie_ lifetime => 0 => 0
session.cookie_ path => / => /
session.cookie_ secure => Off => Off
session.entropy _file => no value => no value
session.entropy _length => 0 => 0
session.gc_divi sor => 1000 => 1000
session.gc_maxl ifetime => 1440 => 1440
session.gc_prob ability => 1 => 1
session.hash_bi ts_per_characte r => 5 => 5
session.hash_fu nction => 0 => 0
session.name => PHPSESSID => PHPSESSID
session.referer _check => no value => no value
session.save_ha ndler => files => files
session.save_pa th => no value => no value
session.seriali ze_handler => php => php
session.use_coo kies => On => On
session.use_onl y_cookies => Off => Off
session.use_tra ns_sid => 0 => 0

SimpleXML

Simplexml support => enabled
Revision => $Revision: 1.151.2.10 $
Schema support => enabled

SPL

SPL support => enabled
Interfaces => Countable, OuterIterator, RecursiveIterat or, SeekableIterato r, SplObserver, SplSubject
Classes => AppendIterator, ArrayIterator, ArrayObject, BadFunctionCall Exception, BadMethodCallEx ception, CachingIterator , DirectoryIterat or, DomainException , EmptyIterator, FilterIterator, InfiniteIterato r, InvalidArgument Exception, IteratorIterato r, LengthException , LimitIterator, LogicException, NoRewindIterato r, OutOfBoundsExce ption, OutOfRangeExcep tion, OverflowExcepti on, ParentIterator, RangeException, RecursiveArrayI terator, RecursiveCachin gIterator, RecursiveDirect oryIterator, RecursiveFilter Iterator, RecursiveIterat orIterator, RuntimeExceptio n, SimpleXMLIterat or, SplFileInfo, SplFileObject, SplObjectStorag e, SplTempFileObje ct, UnderflowExcept ion, UnexpectedValue Exception

standard

Regex Library => Bundled library enabled
Dynamic Library Support => enabled
Path to sendmail => /usr/sbin/sendmail -t -i

Directive => Local Value => Master Value
assert.active => 1 => 1
assert.bail => 0 => 0
assert.callback => no value => no value
assert.quiet_ev al => 0 => 0
assert.warning => 1 => 1
auto_detect_lin e_endings => 0 => 0
default_socket_ timeout => 60 => 60
safe_mode_allow ed_env_vars => PHP_ => PHP_
safe_mode_prote cted_env_vars => LD_LIBRARY_PATH => LD_LIBRARY_PATH
url_rewriter.ta gs => a=href,area=hre f,frame=src,inp ut=src,form=fak eentry => a=href,area=hre f,frame=src,inp ut=src,form=fak eentry
user_agent => no value => no value

tokenizer

Tokenizer Support => enabled

xml

XML Support => active
XML Namespace Support => active
libxml2 Version => 2.6.20

xmlreader

XMLReader => enabled

xmlrpc

core library version => xmlrpc-epi v. 0.51
php extension version => 0.51
author => Dan Libby
homepage => http://xmlrpc-epi.sourceforge.net
open sourced by => Epinions.com

xmlwriter

XMLWriter => enabled

zlib

ZLib Support => enabled
Stream Wrapper support => compress.zlib://
Stream Filter support => zlib.inflate, zlib.deflate
Compiled Version => 1.2.2.2
Linked Version => 1.2.2.2

Directive => Local Value => Master Value
zlib.output_com pression => Off => Off
zlib.output_com pression_level => -1 => -1
zlib.output_han dler => no value => no value

Additional Modules

Module Name

Environment

Variable => Value
_ => /usr/local/bin/php
KDEDIR => /usr
GNOME_KEYRING_S OCKET => /tmp/keyring-KVv0Kv/socket
LESSOPEN => |/usr/bin/lesspipe.sh %s
TNS_ADMIN => /oracle/product/10g/network/admin
QTDIR => /usr/lib/qt-3.3
LPDEST => lpt0
GDMSESSION => gnome
ENV => /home/mgogala/.kshrc
GDM_XSERVER_LOC ATION => local
SHLVL => 0
GTK_RC_FILES => /etc/gtk/gtkrc:/home/mgogala/.gtkrc-1.2-gnome2
SHELL => /bin/ksh
USER => mgogala
EDITOR => vi
SSH_ASKPASS => /usr/libexec/openssh/gnome-ssh-askpass
DESKTOP_SESSION => gnome
SSH_AGENT_PID => 2283
QT_HOME => /usr/lib/qt-3.3
ORACLE_HOME => /oracle/product/10g
DISPLAY => :0.0
PAGER => less
SDL_DSP_NOSELEC T => 1
SESSION_MANAGER => local/medo.noip.com:/tmp/.ICE-unix/2255
HISTSIZE => 200
EPC_DISABLED => true
LS_COLORS => no=00:fi=00:di= 00;34:ln=00;36: pi=40;33:so=00; 35:bd=40;33;01: cd=40;33;01:or= 01;05;37;41:mi= 01;05;37;41:ex= 00;32:*.cmd=00; 32:*.exe=00;32: *.com=00;32:*.b tm=00;32:*.bat= 00;32:*.sh=00;3 2:*.csh=00;32:* .tar=00;31:*.tg z=00;31:*.arj=0 0;31:*.taz=00;3 1:*.lzh=00;31:* .zip=00;31:*.z= 00;31:*.Z=00;31 :*.gz=00;31:*.b z2=00;31:*.bz=0 0;31:*.tz=00;31 :*.rpm=00;31:*. cpio=00;31:*.jp g=00;35:*.gif=0 0;35:*.bmp=00;3 5:*.xbm=00;35:* .xpm=00;35:*.pn g=00;35:*.tif=0 0;35:
PATH => /oracle/product/10g/bin:/usr/local/bin:/usr/bin:/usr/sbin:/bin:/sbin:/usr/X11R6/bin:/usr/local/java/bin:/usr/lib/qt-3.3/bin:/home/mgogala/bin:.
GNOME_DESKTOP_S ESSION_ID => Default
DBUS_SESSION_BU S_ADDRESS => unix:abstract=/tmp/dbus-yzQywxBvjk,guid =3d6e4944f659b2 7d011792a3d7528 900
LOGNAME => mgogala
COLORTERM => gnome-terminal
LD_LIBRARY_PATH => /oracle/product/10g/lib
XAUTHORITY => /home/mgogala/.Xauthority
WINDOWID => 20973296
TERM => vt100
ORA_NLS10 => /oracle/product/10g/nls/data
SQLPATH => /home/mgogala/sql
LANG => en_US
HOSTNAME => medo.noip.com
USERNAME => mgogala
INPUTRC => /etc/inputrc
JAVA_HOME => /usr/local/java
MAIL => /var/spool/mail/mgogala
NLS_LANG => AMERICAN_AMERIC A.WE8ISO8859P1
TWO_TASK => LOCAL
JRE => /usr/local/java/jre
PWD => /home/mgogala
LESS => -R -d
MANPATH => /usr/man:/usr/share/man:/usr/local/man:/usr/X11R6/man:/opt/wine/man:/usr/local/share/man
G_BROKEN_FILENA MES => 1
HISTFILE => /home/mgogala/.sh_history
HOME => /home/mgogala
SSH_AUTH_SOCK => /tmp/ssh-nulhCt2255/agent.2255

PHP Variables

Variable => Value
_SERVER["_"] => /usr/local/bin/php
_SERVER["KDEDIR"] => /usr
_SERVER["GNOME_KEYRING_ SOCKET"] => /tmp/keyring-KVv0Kv/socket
_SERVER["LESSOPEN"] => |/usr/bin/lesspipe.sh %s
_SERVER["TNS_ADMIN"] => /oracle/product/10g/network/admin
_SERVER["QTDIR"] => /usr/lib/qt-3.3
_SERVER["LPDEST"] => lpt0
_SERVER["GDMSESSION "] => gnome
_SERVER["ENV"] => /home/mgogala/.kshrc
_SERVER["GDM_XSERVER_LO CATION"] => local
_SERVER["SHLVL"] => 0
_SERVER["GTK_RC_FIL ES"] => /etc/gtk/gtkrc:/home/mgogala/.gtkrc-1.2-gnome2
_SERVER["SHELL"] => /bin/ksh
_SERVER["USER"] => mgogala
_SERVER["EDITOR"] => vi
_SERVER["SSH_ASKPAS S"] => /usr/libexec/openssh/gnome-ssh-askpass
_SERVER["DESKTOP_SESSIO N"] => gnome
_SERVER["SSH_AGENT_ PID"] => 2283
_SERVER["QT_HOME"] => /usr/lib/qt-3.3
_SERVER["ORACLE_HOM E"] => /oracle/product/10g
_SERVER["DISPLAY"] => :0.0
_SERVER["PAGER"] => less
_SERVER["SDL_DSP_NOSELE CT"] => 1
_SERVER["SESSION_MANAGE R"] => local/medo.noip.com:/tmp/.ICE-unix/2255
_SERVER["HISTSIZE"] => 200
_SERVER["EPC_DISABL ED"] => true
_SERVER["LS_COLORS"] => no=00:fi=00:di= 00;34:ln=00;36: pi=40;33:so=00; 35:bd=40;33;01: cd=40;33;01:or= 01;05;37;41:mi= 01;05;37;41:ex= 00;32:*.cmd=00; 32:*.exe=00;32: *.com=00;32:*.b tm=00;32:*.bat= 00;32:*.sh=00;3 2:*.csh=00;32:* .tar=00;31:*.tg z=00;31:*.arj=0 0;31:*.taz=00;3 1:*.lzh=00;31:* .zip=00;31:*.z= 00;31:*.Z=00;31 :*.gz=00;31:*.b z2=00;31:*.bz=0 0;31:*.tz=00;31 :*.rpm=00;31:*. cpio=00;31:*.jp g=00;35:*.gif=0 0;35:*.bmp=00;3 5:*.xbm=00;35:* .xpm=00;35:*.pn g=00;35:*.tif=0 0;35:
_SERVER["PATH"] => /oracle/product/10g/bin:/usr/local/bin:/usr/bin:/usr/sbin:/bin:/sbin:/usr/X11R6/bin:/usr/local/java/bin:/usr/lib/qt-3.3/bin:/home/mgogala/bin:.
_SERVER["GNOME_DESKTOP_ SESSION_ID"] => Default
_SERVER["DBUS_SESSION_B US_ADDRESS"] => unix:abstract=/tmp/dbus-yzQywxBvjk,guid =3d6e4944f659b2 7d011792a3d7528 900
_SERVER["LOGNAME"] => mgogala
_SERVER["COLORTERM"] => gnome-terminal
_SERVER["LD_LIBRARY_PAT H"] => /oracle/product/10g/lib
_SERVER["XAUTHORITY "] => /home/mgogala/.Xauthority
_SERVER["WINDOWID"] => 20973296
_SERVER["TERM"] => vt100
_SERVER["ORA_NLS10"] => /oracle/product/10g/nls/data
_SERVER["SQLPATH"] => /home/mgogala/sql
_SERVER["LANG"] => en_US
_SERVER["HOSTNAME"] => medo.noip.com
_SERVER["USERNAME"] => mgogala
_SERVER["INPUTRC"] => /etc/inputrc
_SERVER["JAVA_HOME"] => /usr/local/java
_SERVER["MAIL"] => /var/spool/mail/mgogala
_SERVER["NLS_LANG"] => AMERICAN_AMERIC A.WE8ISO8859P1
_SERVER["TWO_TASK"] => LOCAL
_SERVER["JRE"] => /usr/local/java/jre
_SERVER["PWD"] => /home/mgogala
_SERVER["LESS"] => -R -d
_SERVER["MANPATH"] => /usr/man:/usr/share/man:/usr/local/man:/usr/X11R6/man:/opt/wine/man:/usr/local/share/man
_SERVER["G_BROKEN_FILEN AMES"] => 1
_SERVER["HISTFILE"] => /home/mgogala/.sh_history
_SERVER["HOME"] => /home/mgogala
_SERVER["SSH_AUTH_S OCK"] => /tmp/ssh-nulhCt2255/agent.2255
_SERVER["PHP_SELF"] => -
_SERVER["SCRIPT_NAM E"] => -
_SERVER["SCRIPT_FILENAM E"] =>
_SERVER["PATH_TRANSLATE D"] =>
_SERVER["DOCUMENT_R OOT"] =>
_SERVER["REQUEST_TI ME"] => 1145667671
_SERVER["argv"] => Array
(
[0] => -
)

_SERVER["argc"] => 1

PHP License
This program is free software; you can redistribute it and/or modify
it under the terms of the PHP License as published by the PHP Group
and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any
questions about PHP licensing, please contact license@php.net.


--

http://www.mgogala.com

[Christopher.Jones@oracle.com]

Re: oracle mystery

hegyvari@ardent s.hu writes:
[color=blue]
> ps: I tried to migrate to the integrated zend instant client solution,
> but then the letters with accents ceased to appear. Instant client does
> not use nls_lang, which was set to american_americ a.ee8iso8859p2. I
> would really appreciate any ideas how to get my special letters appear
> again with instant client.
>[/color]

Zend Core for Oracle includes Oracle Instant Client (IC) so it can
connect to the database. (You can manually configure PHP and other
database clients to use IC if you want to do it all yourself). IC is
the same code as the full Oracle Client; it's effectively the bundling
of the message and language data which has changed.

You can use NLS_LANG and all the other Oracle client-side variables
(TNS_ADMIN etc.) with Oracle Instant Client. Just set them in the
environment that starts the web server.

Oracle's "Oracle® Database Express Edition 2 Day Plus PHP Developer
Guide"

http://download-west.oracle.com/docs/cd/B25329_01/doc/appdev.102/b25317/toc.htm

includes a useful chapter on PHP-Oracle globalization.

Make sure you get the re-factored oci8 extension source code.
See http://blogs.oracle.com/opal/2006/03/20#a6 and
http://blogs.oracle.com/opal/2006/03/30#a10

Chris

--
Christopher Jones, Oracle Corporation, Australia.
Email: Christopher.Jon es@oracle.com
Blog: http://blogs.oracle.com/opal/

[Christopher.Jones@oracle.com]

Re: oracle mystery

Mladen Gogala <gogala@sbcglob al.net> writes:
[color=blue]
> As far as the instant client goes, it is just like fast food: it
> kills you if you use it too often. You're much better off with a
> full-fledged Oracle client.[/color]

Hi Mladen,

What's your rationale? Instant Client can be extremely convenient and
is the same code as the full client.

Chris

--
Christopher Jones, Oracle Corporation, Australia.
Email: Christopher.Jon es@oracle.com
Blog: http://blogs.oracle.com/opal/