472,354 Members | 1,591 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,354 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 4513
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: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
1
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
0
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

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.