[PHP-DB] Error

Hi I have a page that inserts data into a oracle table using a oracle stored procedure via php. However when the php runs I get the following error: Warning: oci_execute() [function.oci-execute]: ORA-06550: line 2, column 7: PLS-00553: character set name is not recognized ORA-06550: line 0,

RE: [PHP-DB] Re: Error

This could be a problem with your ORACLE_HOME and/or NLS_LANG environment variables. These need to be set for your user account running the web server BEFORE the web server is started. Don't try to set these in your php script or you'll get strange results. David Skyers wrote: Hi I have a page

[PHP-DB] List menus

Hello, How do you create a database driven list menu, and record the options that a user has chosen. And then display the list menu with those chosen option selected. Please select from list PHP 3 --- PHP 4 PHP 5 Regards, David

RE: [PHP-DB] Special Character

To: David Skyers Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Special Character David Skyers wrote: Hi Kevin, Thanks for this, it got rid of my special characters. However I now have a problem with foreign characters. Example 'De l'Âge du fer au haut Moyen Âge.' gets inserted

RE: [PHP-DB] Special Character

the data, if I run the oracle procedure directly in oracle it inserts the special characters okay. The problem seems to be with the way php execute the procedure. Any ideas? David _ From: Kevin Murphy [mailto:[EMAIL PROTECTED] Sent: 16 November 2006 16:45 To: David Skyers Cc: php-db

[PHP-DB] Special Character

Hi , We have a problem with storing data into our oracle database that is copied from Microsoft word. A typical example would be a hyphen, if entered directly in an input box this is stored fine. However if copied from Microsoft word it is displayed as a question mark. Has anyone else

RE: [PHP-DB] Special Character

Hi Niel That's the problem I don't know what it is, but I do know that I press the hyphen/minus key on my keyborad. If I type in 'The -' then press enter and copy and paste this from word, it then gets displayed as question mark in Oracle. David -Original Message- From: Niel Archer

RE: [PHP-DB] Special Character

Thanks, The problem is, we will have hundreds of users using Microsoft Word and we cannot switch it off for all of them. Ideally I need some type of string replace function, so no matter what they enter it gets trapped an replaced. It's not the normal hyphens that cause a problem but the long

[PHP-DB] Help Needed!!

and if so how? 2. Can the Oracle database store this type of formatting? 3. Can the data and formatting then be extracted in XML Thanks, David David Skyers Support Analyst Management Systems, EISD, UCL Extension: 41849 Tel: 020 7679 1849 Email: [EMAIL

RE: [PHP-DB] Oracle Stored Procedures

Hi The procedure works fine through Oracle. I can see the correct output. David -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: 12 October 2006 01:15 To: David Skyers Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Oracle Stored Procedures PLS-00553: character set

[PHP-DB] Oracle Stored Procedures

from Oracle... OCILogoff($c); ? David Skyers Support Analyst Management Systems, EISD, UCL Extension: 41849 Tel: 020 7679 1849 Email: [EMAIL PROTECTED]

RE: [PHP-DB] How to stop the server timing out

Hi, Thanks, the echos causes the page to responds after each insert, so the server no longer times out. David -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: 04 October 2006 03:24 To: David Skyers; php-db@lists.php.net Subject: RE: [PHP-DB] How to stop

[PHP-DB] How to stop the server timing out

Hi,I have written a php page and every time I run it, it causes the server to times-out. Is there anything I can do, to get the page to run completely or speed up how the page works. Please note I do not have any control over the server.The page does a select from a table and inserts the

[PHP-DB] Oracle talk to MySQL

Hi Guys, Does anyone know how to make Oracle talk to MySQL? I have data in a MySQL database that I need to get into a Oracle database. Thanks, David David Skyers Support Analyst Management Systems, EISD, UCL Extension: 41849 Tel: 020 7679 1849

[PHP-DB] inserting data into Oracle tables

with something like this. Regards, David -- David Skyers Support Analyst Management Systems, UCL [EMAIL PROTECTED] 020 7679 1849 (internal 41849) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] inserting data into Oracle tables

with something like this. Regards, David -- David Skyers Support Analyst Management Systems, UCL [EMAIL PROTECTED] 020 7679 1849 (internal 41849) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php