NYCPHP Meetup

[nycphp-talk] Oracle NLS_LANG problem: ADD

Hans Zaunere zaunere at yahoo.com
Fri Jun 14 22:27:52 EDT 2002


I might be able to help on this one.

If you don't know already, consider http://orafaq.com and
http://oradoc.photo.net invaluable.  On orafaq.com somewhere, there is
a directory of every ORA-* error message, in addition to the search
ability.  I have the URL at work and will post Monday.

Anyway, although you say you're using the Oracle client, I'm assuming
this is running from Apache/PHP (as opposed to the actual Oracle
client).

If running Apache, you need to make sure that the proper Oracle
environment is actually available via Apache and permissions for the
Apache user.  I generally setup the environment in the apachectl script
in some way.  This ensures that Apache itself actually has the proper
environment, and cane be confirmed with a phpinfo() call.  Also, be
sure Apache has access to the Oracle client resource, which are
generally installed as a different user.

Let me know if this helps, and if not, any more details on the
situation (I use 8i client libs on RH 6.2 to connect to a NT server).

HZ




--- Jeremy Hise <jhise at linuxforbusiness.org> wrote:
> On line 178 I'm also calling a stored procedure that generates a
> value,
> which is bound to a PHP variable for use.
> 
> On Fri, 2002-06-14 at 18:21, Jeremy Hise wrote:
> > Hi All:
> > 
> > I'm running oracle on NT and connecting via the oracle client on RH
> 6.2
> > Kernel version 2.2.14-5.0 ... Oracle 8.1.6
> > 
> > The PHP error I'm getting is:
> > 
> > Warning: OCIStmtExecute: ORA-06550: line 1, column 30: PLS-00553:
> > character set name is not recognized ORA-06550: line 0, column 0:
> > PL/SQL: Compilation unit analysis terminated in
> > /development/jhise/dbmerge_src/class/login.pclass on line 178
> > 
> > I've been looking all over the place and all the pages I've found
> say to
> > correctly set up the NLS_LANG env variable...which I do. I've
> stopped
> > and started apache...even rebooted the whole machine...doesn't seem
> as
> > though any of it makes any difference.
> > 
> > Anyway have any insight?
> > 
> > Thanks!
> > 
> > jhise
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> 
> 
> 
> 


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com



More information about the talk mailing list