473,890 Members | 1,400 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Apr 20 '06 #1
6 4690
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_americ a.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|^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 li*****@php.net.
--
http://www.mgogala.com

Apr 22 '06 #5
he******@ardent s.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_americ a.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****@sbcglob al.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
5233
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 luck yet. Here is a short description of what I did so far: 1. I installed the jdk118_v3-glibc-2.1.3.tar in the /usr/local/ dir and made a symbolic link from /usr/local/java to this 2. I installed all the necessary groups and users (oracle,...
1
8828
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 Informix features that I have come to rely upon. I have looked through the Oracle/Infomix groups and some helpful users have posted some solutions, but many of them seem to be very complex work-arounds for features that were readily available in
0
1776
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 in a datasheet. The user double clicks on a row in that datasheet and a main form (pop up) opens bound to a table with a continuous subform bound to a query.
115
7689
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 transform function. When compiling under gcc on my big-endian PowerPC (Mac OS X), declaring this array as "static" DECREASES the transform throughput by around 5%. However, declaring it as "static" on gcc/Linux/Intel INCREASES the throughput by...
14
2806
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 have running a fairly simple HTTP server (written in python) that i
14
4452
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 timestamps, we frequently use the date() function to "convert" from the Oracle date datatype to the DB2 date datatype. We have used this technique on over 20 Oracle tables for several months with no problem. One table in particular fails with a...
5
7787
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 protocol to connect to my DB2 test server, which is running on Win2003. This test server has recently been migrated to V8. It was previously on V7.2 FP5, and here is where the mystery lies.
2
3578
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 rd@stat2.scn.ru:/usr/src/sys/i386/compile/RDSTAT2-ORACLE i386 uname -a under oracle user : Linux stat2.scn.ru 2.4.2 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23 19:19:43 KRAST 2004 i686 unknown
0
3329
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. http://a.uuload.com/Oracle-Database.htm Unlock the Value of Your IT System Confio Software's Ignite for Oracle uses wait-event analysis to improve database performance by 65% or more. Gain visibility of every Oracle wait event. Download free...
0
9978
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10810
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10918
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10460
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9625
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8015
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7169
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
4270
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3275
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.