473,401 Members | 2,068 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,401 software developers and data experts.

oracle mystery

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_america.ee8iso8859p2. I
would really appreciate any ideas how to get my special letters appear
again with instant client.

Apr 20 '06 #1
6 4631
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

Apr 20 '06 #2
On Thu, 20 Apr 2006 09:56:00 -0700, hegyvari wrote:
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.
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.

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_america.ee8iso8859p2. I
would really appreciate any ideas how to get my special letters appear
again with instant client.


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

Apr 21 '06 #3
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.

Apr 21 '06 #4
On Fri, 21 Apr 2006 07:06:32 -0700, hegyvari wrote:
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.


I have no problems whatsoever. Here is my SW combination:
$ rpm -qa|egrep "^kernel|^httpd-"|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_tags, 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.input => & => &
arg_separator.output => & => &
asp_tags => Off => Off
auto_append_file => no value => no value
auto_globals_jit => On => On
auto_prepend_file => no value => no value
browscap => no value => no value
default_charset => no value => no value
default_mimetype => text/html => text/html
define_syslog_variables => Off => Off
disable_classes => no value => no value
disable_functions => 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_string => no value => no value
error_log => no value => no value
error_prepend_string => 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.comment => #FF8000 => #FF8000
highlight.default => #0000BB => #0000BB
highlight.html => #000000 => #000000
highlight.keyword => #007700 => #007700
highlight.string => #DD0000 => #DD0000
html_errors => Off => On
ignore_repeated_errors => Off => Off
ignore_repeated_source => Off => Off
ignore_user_abort => 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_gpc => Off => Off
magic_quotes_runtime => Off => Off
magic_quotes_sybase => Off => Off
mail.force_extra_parameters => no value => no value
max_execution_time => 0 => 30
max_input_time => 60 => 60
open_basedir => no value => no value
output_buffering => 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_argv => On => Off
register_globals => Off => Off
register_long_arrays => Off => Off
report_memleaks => On => On
report_zend_debug => Off => Off
safe_mode => Off => Off
safe_mode_exec_dir => no value => no value
safe_mode_gid => Off => Off
safe_mode_include_dir => no value => no value
sendmail_from => no value => no value
sendmail_path => /usr/sbin/sendmail -t -i => /usr/sbin/sendmail -t -i
serialize_precision => 100 => 100
short_open_tag => On => On
SMTP => localhost => localhost
smtp_port => 25 => 25
sql.safe_mode => Off => Off
track_errors => Off => Off
unserialize_callback_func => no value => no value
upload_max_filesize => 2M => 2M
upload_tmp_dir => no value => no value
user_dir => no value => no value
variables_order => GPCS => GPCS
xmlrpc_error_number => 0 => 0
xmlrpc_errors => Off => Off
y2k_compliance => On => On
zend.ze1_compatibility_mode => Off => Off

bz2

BZip2 Support => Enabled
Stream Wrapper support => compress.bz2://
Stream Filter support => bzip2.decompress, 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_latitude => 31.7667 => 31.7667
date.default_longitude => 35.2333 => 35.2333
date.sunrise_zenith => 90.583333 => 90.583333
date.sunset_zenith => 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_encoding => ISO-8859-1 => ISO-8859-1
iconv.internal_encoding => ISO-8859-1 => ISO-8859-1
iconv.output_encoding => 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_prefetch => 10 => 10
oci8.max_persistent => -1 => -1
oci8.old_oci_close_semantics => 0 => 0
oci8.persistent_timeout => -1 => -1
oci8.ping_interval => 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_start => Off => Off
session.bug_compat_42 => Off => Off
session.bug_compat_warn => On => On
session.cache_expire => 180 => 180
session.cache_limiter => 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_divisor => 1000 => 1000
session.gc_maxlifetime => 1440 => 1440
session.gc_probability => 1 => 1
session.hash_bits_per_character => 5 => 5
session.hash_function => 0 => 0
session.name => PHPSESSID => PHPSESSID
session.referer_check => no value => no value
session.save_handler => files => files
session.save_path => no value => no value
session.serialize_handler => php => php
session.use_cookies => On => On
session.use_only_cookies => Off => Off
session.use_trans_sid => 0 => 0

SimpleXML

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

SPL

SPL support => enabled
Interfaces => Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes => AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException

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_eval => 0 => 0
assert.warning => 1 => 1
auto_detect_line_endings => 0 => 0
default_socket_timeout => 60 => 60
safe_mode_allowed_env_vars => PHP_ => PHP_
safe_mode_protected_env_vars => LD_LIBRARY_PATH => LD_LIBRARY_PATH
url_rewriter.tags => a=href,area=href,frame=src,input=src,form=fakeentr y => a=href,area=href,frame=src,input=src,form=fakeentr y
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_compression => Off => Off
zlib.output_compression_level => -1 => -1
zlib.output_handler => no value => no value

Additional Modules

Module Name

Environment

Variable => Value
_ => /usr/local/bin/php
KDEDIR => /usr
GNOME_KEYRING_SOCKET => /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_LOCATION => 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_NOSELECT => 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;4 1:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b tm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar= 00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00 ;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.b z2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio= 00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00 ;35:*.xpm=00;35:*.png=00;35:*.tif=00;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_SESSION_ID => Default
DBUS_SESSION_BUS_ADDRESS => unix:abstract=/tmp/dbus-yzQywxBvjk,guid=3d6e4944f659b27d011792a3d7528900
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_AMERICA.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_FILENAMES => 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_LOCATION"] => local
_SERVER["SHLVL"] => 0
_SERVER["GTK_RC_FILES"] => /etc/gtk/gtkrc:/home/mgogala/.gtkrc-1.2-gnome2
_SERVER["SHELL"] => /bin/ksh
_SERVER["USER"] => mgogala
_SERVER["EDITOR"] => vi
_SERVER["SSH_ASKPASS"] => /usr/libexec/openssh/gnome-ssh-askpass
_SERVER["DESKTOP_SESSION"] => gnome
_SERVER["SSH_AGENT_PID"] => 2283
_SERVER["QT_HOME"] => /usr/lib/qt-3.3
_SERVER["ORACLE_HOME"] => /oracle/product/10g
_SERVER["DISPLAY"] => :0.0
_SERVER["PAGER"] => less
_SERVER["SDL_DSP_NOSELECT"] => 1
_SERVER["SESSION_MANAGER"] => local/medo.noip.com:/tmp/.ICE-unix/2255
_SERVER["HISTSIZE"] => 200
_SERVER["EPC_DISABLED"] => 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;4 1:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b tm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar= 00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00 ;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.b z2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio= 00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00 ;35:*.xpm=00;35:*.png=00;35:*.tif=00;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_BUS_ADDRESS"] => unix:abstract=/tmp/dbus-yzQywxBvjk,guid=3d6e4944f659b27d011792a3d7528900
_SERVER["LOGNAME"] => mgogala
_SERVER["COLORTERM"] => gnome-terminal
_SERVER["LD_LIBRARY_PATH"] => /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_AMERICA.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_FILENAMES"] => 1
_SERVER["HISTFILE"] => /home/mgogala/.sh_history
_SERVER["HOME"] => /home/mgogala
_SERVER["SSH_AUTH_SOCK"] => /tmp/ssh-nulhCt2255/agent.2255
_SERVER["PHP_SELF"] => -
_SERVER["SCRIPT_NAME"] => -
_SERVER["SCRIPT_FILENAME"] =>
_SERVER["PATH_TRANSLATED"] =>
_SERVER["DOCUMENT_ROOT"] =>
_SERVER["REQUEST_TIME"] => 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 li*****@php.net.
--
http://www.mgogala.com

Apr 22 '06 #5
he******@ardents.hu writes:
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_america.ee8iso8859p2. I
would really appreciate any ideas how to get my special letters appear
again with instant client.


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...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: Ch***************@oracle.com
Blog: http://blogs.oracle.com/opal/
Apr 26 '06 #6
Mladen Gogala <go****@sbcglobal.net> writes:
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.


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: Ch***************@oracle.com
Blog: http://blogs.oracle.com/opal/
Apr 26 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jan Bols | last post by:
I've been trying to install Oracle 8.1.7 on a fresh Mandrake 9.1 O.S for days, but I'm still not able to get it running. I've tried several install instructions that I found on the internet but no...
1
by: Phil Hindmoor | last post by:
Hi, I am sure if anyone can help me, you guys can! I am an Informix Developer, moving to Oracle 8i and later databases. I am struggling to find the Oracle equivelant to many of the useful...
0
by: William Wisnieski | last post by:
Hello Everyone: I'm having a very strange problem occurring with my Access 2000 database. I call it the "mystery record." Here's the story: I have a query by form that returns a record set...
115
by: Mark Shelor | last post by:
I've encountered a troublesome inconsistency in the C-language Perl extension I've written for CPAN (Digest::SHA). The problem involves the use of a static array within a performance-critical...
14
by: jojoba | last post by:
Hi, I hope this post is ok for this group. Here's my deal: I have two computers on my LAN at home. One desktop. One laptop. Both computers are wireless enabled (and wired enabled too). I...
14
by: peteh | last post by:
Hi All; We have many production jobs that "load from cursor" to a UDB/AIX 8.2 (with dpf) data warehouse from source tables residing Oracle 9i. Since Oracle dates are (roughly) equivalent to DB2...
5
by: Scav | last post by:
Helpful folks, I am having a problem getting Oracle's Transparent Gateway for DRDA product to interface with DB2 UDB for LUW 8.1.14. The Gateway product is running on Linux and using DRDA...
2
by: Ruslan A Dautkhanov | last post by:
Hello ! I'm about to install O9i on FreeBSD box. uname -a: FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23 19:19:43 KRAST 2004...
0
by: Jack | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available....
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.