Re: [PHP-DB] PHP and OCI NLS behaviour

2002-04-18 Thread Rouvas Stathis
-- +--+ |..| |||| || Stathis|| ||Rouvas || |||| |++| +-....-+ .--. / /\ \ / /==\ \ /\ \/ [EMAIL PROTECTED] -- PHP Database Mailing List

Re: [PHP-DB] PHP and OCI NLS behaviour

2002-04-16 Thread Rouvas Stathis
: http://www.php.net/unsub.php -- +--+ |..| |||| || Stathis|| ||Rouvas

Re: [PHP-DB] Format of date retrieved from Oracle8

2001-10-02 Thread Rouvas Stathis
Hi, SELECT TO_CHAR(FIELD,'DD/MM/ HH24:MI:SS') FROM TABLE -Stathis. Karsten Dambekalns wrote: Hi everybody, I have a PHP application using an Oracle database. This database has been built before the application was rewritten in PHP, so I couldn't switch to MySQL :-/ Now the

Re: [PHP-DB] Connection to Oracle8i

2001-08-15 Thread rouvas
You have to compile PHP with Oracle option first and then try connecting to any Oracle backend. If you already have done that, you should use the 'oci' family of calls instead of the 'oracle' ones, unless you are trying to access an Oracle older than version 8. In your mail you state that you use

Re: [PHP-DB] Persistent connection Oracle 8.0.5 and PHP 4.0.6

2001-07-17 Thread Rouvas Stathis
Try using OciPLogon instead of OciLogon. -Stathis. Jean Castonguay wrote: Hi, I try to make a persistent connection with Oracle because I retrieve information in Oracle but each call I login and it's so long. Is it possible to keep the first connection all the times before i close it.

Re: [PHP-DB] Transmitting Arrays

2001-03-21 Thread Rouvas Stathis
I don't think that serialize/unserialize was meant to be used that way. I would try WDDX which is specifically designed for the web. -Stathis. Mick Lloyd wrote: Mark I've had similar problems in the past. It's my understanding that you can't pass arrays between scripts, except when using

Re: [PHP-DB] PHP/Oracle/mod_ssl/Apache

2001-03-12 Thread Rouvas Stathis
Hi Steve, if you use OciPLogon to connect to ORA, bad luck. Replace with OCiLogon and your problesm are gone. Of course, *always* remember to ocilogoff() your open connections. In my experience OCIPLogon is broken. It never closes open connections to ora, instead it waits for them to timeout,

Re: [PHP-DB] How to migrate Oracle 4.01 database?

2001-03-09 Thread Rouvas Stathis
Oracle.4.01!!! That's a blast from the past!!! Best bet: export everything and import into Ora.8i. It worked for me doing an Ora.6.xx to Ora.8.1.6.1 migration:-) GOOD LUCK. -Stathis. wrote: Hi, I have a database based on Oracle 4.01. Now I want to migrate it to Oracle 8i. Does anyone