[PHP-DB] Re: [External] : [PHP-DB] PDO to Oracle db and secure external password store aka wallet for authentication

On 28/9/21 6:59 pm, Mathias Zarick wrote: Hi there, I am wondering how it would be possible to use authentication using a secure external password store aka wallet with PDO OCI. See Oracle external authentication and OCI_CRED_EXT in the underground php oracle manual. and

Re: [PHP-DB] Getting PDO-OCI to work in PHP 7

Possibly try a two stage build: - build your main PHP without PDO_OCI - build PDO_OCI as a shared library with a simplified configure command that doesn't have ldap. Then move the resulting PDO_OCI library to your first PHP install and update php.ini. Then test thoroughly. I have had to do

Re: [PHP-DB] Re: PHP 7 and sqlsrv

On 4/10/15 3:20 PM, Jim Giner wrote: On 4/10/2015 4:03 PM, John Hermsen wrote: I was wondering if there is anyone who manager to compile the sqlsrv driver for php 7. I have tried, but I haven't been able to get it compiled yet. Thanks, John php 7?? I didn't even see php 6 go past me!

Re: [PHP-DB] Probleme upper accents

On 4/5/13 7:23 AM, Matijn Woudt wrote: On Fri, Apr 5, 2013 at 3:19 PM, Toby Hart Dyke t...@hartdyke.com wrote: It looks similar to this bug: http://bugs.php.net/bug.php?**id=54379http://bugs.php.net/bug.php?id=54379- possibly fixed in a later version? Your PHP is pretty elderly. Toby

Re: [PHP-DB] Debugger

On 10/24/2012 05:02 PM, Ethan Rosenberg, PhD wrote: Dear list - A. Is anyone aware of a debugger that: 1] will step thru the code, 2] will stop at a point that input is requested [eg, form] and allow input? B. Aptana gives the following message: 'Launching Firefox' internal server has

Re: [PHP-DB] Oracle NClobs

On 08/05/2011 09:08 AM, Lester Caine wrote: n.a.mor...@brighton.ac.uk wrote: Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. It may not be related, but there were a number of issues with BLOB ids in Firebird which were not fixed until 5.2.7, I don't have anything

Re: [PHP-DB] Oracle NClobs

On 08/05/2011 08:55 AM, n.a.mor...@brighton.ac.uk wrote: Guys, Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. The following piece of code works with a CLOB, but not with an NCLOB. Can anyone shed any light please? There is no support for NCLOB in PHP OCI8.

Re: [PHP-DB] Oracle PDO UTF-8 problem

Glad you resolved it. Overall, I have to recommend the OCI8 extension over the unmaintained (like much of PDO) PDO_OCI extension. Chris On 01/13/2011 11:36 PM, Karsten Lehmann wrote: I found out that the error depends on the wrong character set of the Oracle Database. In my case this was a

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

ZeYuan Zhang wrote: Hi there. Why oci_commit function always returns true even when the transaction fails. I just copied the code in the php manual [Example 1636. oci_commit() example], and runned it, the situation is as follows: * The statements do commit at the moment when oci_commit

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

Chris wrote: ZeYuan Zhang wrote: Hi there. Why oci_commit function always returns true even when the transaction fails. I just copied the code in the php manual [Example 1636. oci_commit() example], and runned it, the situation is as follows: * The statements do commit at the moment

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

Chris wrote: Christopher Jones wrote: Chris wrote: ZeYuan Zhang wrote: Hi there. Why oci_commit function always returns true even when the transaction fails. I just copied the code in the php manual [Example 1636. oci_commit() example], and runned it, the situation

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

echo Second Insert\n; $s = oci_parse($c, insert into t_tab values ( 1,-1)); $r = oci_execute($s, OCI_DEFAULT); // Explore the difference with and without OCI_DEFAULT if (!$r) { $m = oci_error($s); trigger_error('Could not execute: '. $m['message'], E_USER_ERROR); } $r =

Re: [PHP-DB] ocilogon core dump on Solaris 10 X86 with php-5.2.9 and Oracle 10g

At a guess, there is a clash with the SSL libraries or it is a libpthread problem - google around for background. Chris Andre LAGADEC wrote: Hello, I am on Solaris 10 X86 with DELL IP , and I compile Php-5.2.9 with Apache2, Mysql6 and Oracle10g with success. But when I want to connect to

Re: [PHP-DB] dl () problem

Check the notes: http://www.php.net/manual/en/function.dl.php#function.dl.notes Christoph Rosse wrote: stupid question ... but did you restart apache after editing php.ini ? Sent from my iPhone On 26.01.2010, at 16:02, Murat Beyhan bey...@deprem.gov.tr wrote: Dear All, I have updated

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

Andy Shellam (Mailing Lists) wrote: First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection. Therefore,

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

, but perhaps it would be worth waiting for 5.3. -Sara The mysqli extension appears to use mysqli_ as the hash key prefix so there won't be PHP connection structure sharing here either. Chris Christopher Jones wrote: Andy Shellam (Mailing Lists) wrote: First, when connecting, the function

[PHP-DB] Potential changes for the OCI8 extension for Oracle 11.2

Now that Oracle Database 11.2 has been released (http://blogs.oracle.com/opal/2009/09/oracle_database_11gr2_enhancem.html), we'd like to make some enhancements to PHP OCI8 for PHP 5.3.2 PHP 6: 1. Allow the oci_set_prefetch() count to be 0, i.e. just fetch/buffer one row at a time and don't

Re: [PHP-DB] What's the number scheme for 'colno' for Select call in PDO driver

Sanjeev Kumar wrote: Hi, In the implemetation of Pdo-driver (extension) , what's the Sequence/Index scheme for parameter: 'colno' ? This param 'colno' is input in driver calls (of PDO statement) : int SKEL_stmt_describe_col(pdo_stmt_t *stmt, int colno TSRMLS_DC) int

Re: [PHP-DB] Fedora 9--10 ..now oracle connect error

Fred Silsbee wrote: Oracle Connect Error What error? What Oracle client libraries do you have? Where are they located just upgraded Fedora 9-10 using new php.ini file containing: ; Note: packaged extension modules are now loaded via the .ini files ; found in the directory

Re: [PHP-DB] Fedora 9--10 ..now oracle connect error

Fred Silsbee wrote: in /etc/httpd/conf/httpd.conf SetEnv ORACLE_HOSTNAME localhost.localdomain SetEnv TNS_ADMIN /u01/app/oracle/product/11.1.0/db_1/network/admin SetEnv ORACLE_BASE /u01/app/oracle SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1 SetEnv ORACLE_SID lmkiiiGDNSID

Re: [PHP-DB] Prepared Statement Insert Problem

kesavan trichy rengarajan wrote: could be rewritten as: mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin, sha1($password), $email); Turning on E_STRICT in PHP 5.3 will show PHP Strict Standards: Only variables should be passed by reference This is also true in earlier

Re: [PHP-DB] Problem with PDO Mysql and FETCH::ASSOC

Thomas Robitaille wrote: I've managed to fix the issue by switching to a 32-bit installation of MySQL and Apache. The problem appeared to be due to the 64-bit versions somehow. If you think there's a bug (and you tested the latest version of PHP), please report the problem at

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

Grant Croker wrote: DYLD_LIBRARY_PATH=/opt/oracle/instanceclient LD_LIBRARY_PATH=/opt/oracle/instanceclient ORACLE_BASE=/opt/oracle/instanceclient ORACLE_HOME=/opt/oracle/instanceclient export DYLD_LIBRARY_PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME (note: As Chris Jones mentioned

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

Chris wrote: Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries in/Library/WebServer/Documents/oracle.php on line 25 Oracle

Re: [PHP-DB] sqlnet.ora doesn't seem to be read since oci8 1.3.4

Jérôme Loyet wrote: Hello, I used to use oci8 version 1.2.3 and I wanted to update to last version (1.3.4). Everything works fine except the fact that sqlnet.ora does not seems to be read. I use the following string to describe my database in oci_connect: MEN1PRD. In sqlnet.ora there is

Re: [PHP-DB] sqlnet.ora doesn't seem to be read since oci8 1.3.4

Jérôme Loyet wrote: My init script where the ENV are set: export ORACLE_HOME=/usr/local/oracle/VERSIONS/Linux/CL.9.2.0 PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/network/admin:$ORACLE_HOME/lib:/usr/local/bin (The admin and lib directories aren't needed in the PATH because they don't contain

Re: [PHP-DB] oci_connect returns warning if provided with the 4th param(charset)

Tonado wrote: Hi all, I used the following in my code oci_connect('$user','$pass',$connectionString,'UTF8'); and got the following warning: Warning: oci_connect() [function.oci-connect]: Invalid character set name: UTF8 I tried many times and found it could only work when I

Re: [PHP-DB] oracle pooling

Themis Vassiliadis wrote: DRCP is really a big improvement. But for me it has a great holdback: the pool controlled in the server side isn't defined for a specific schema, so if we have an application server serving different connections demanding different credentials certainly the

Re: [PHP-DB] oracle pooling

Themis Vassiliadis wrote: On Tue, Dec 2, 2008 at 4:18 PM, Christopher Jones [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Oracle 11g DRCP support is available in PHP. See this whitepaper: http://www.oracle.com/technology/tech/php/pdf/php-scalability-ha-twp.pdf Change

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

Fred Silsbee wrote: GREAT!!but how! How what? http://us.php.net/manual/en/oci8.setup.php What about it? [phpinfo output of] Compile-time ORACLE_HOME no value The lack of a value here is an artifact aka buglet of installing from the PECL package. I'll add it to the

Re: [PHP-DB] close clue?

Fred Silsbee wrote: http://bugs.php.net/bug.php?id=43186 Why do you think it's a clue? Are you getting a crash? Does your PHP command line work? So far we have almost zero information about your configuration in particular we don't have phpinfo() output (despite suggestions you check it).

Re: [PHP-DB] oci_connect

Fred Silsbee wrote: I have the following in /etc/httpd/conf/httpd.conf SetEnv ORACLE_HOSTNAME localhost.localdomain SetEnv TNS_ADMIN /u01/app/oracle/product/11.1.0/db_1/network/admin SetEnv ORACLE_BASE /u01/app/oracle SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1 SetEnv

Re: [PHP-DB] what the php guys need to do

Fred Silsbee wrote: provide some detailed instructions for oc8/linux install that leave no gaps instructions that work for newbies For newbies we recommend installing Zend Core for Oracle. Are you the same person as person who has been posting to the OTN forum, e.g. this post

Re: [PHP-DB] what the php guys need to do

I'm CCing the php-db list. Fred Silsbee wrote: install Zend?...never! I have Fedora 9 and 11g1 Enterprise I have Apache working and Oracle 11g1 installed and working! Zend installs both of these and could screw up my working system. Zend Core for Oracle will use your existing Apache. It

Re: [PHP-DB] what the php guys need to do

I'm CCing php-db again. Fred Silsbee wrote: This worked: sqlplus hr/[EMAIL PROTECTED] so I tried: (didn't work) if ($conn=oci_connect('hr', 'hr', '//localhost/LMKIIIGD')) Excuse me repeating the example PHP code I gave earlier for this SQL*Plus case: Or if you connect like:

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

Fred Silsbee wrote: there is a file /etc/httpd/conf/httpd.conf I tried putting the ORACLE_HOME in this file but it failed What failed and how? How was it set? [phpinfo output of] Compile-time ORACLE_HOME no value The lack of a value here is an artifact aka buglet of installing from

[PHP-DB] Re: [PECL-DEV] oci8

Hi Fred, [EMAIL PROTECTED] is a development mail list. The best place to post to is [EMAIL PROTECTED] I'm ccing that list: please remove pecl-dev from any followup mail. Fred Silsbee wrote: I have Fedora 9 2.6.27.5-37.fc9.i686 and Oracle 11g1 [EMAIL PROTECTED] oci8-1.3.4$ phpize also

Re: [PHP-DB] sql injections/best practises

mignon hunter wrote: Hi Christopher One other question. Our current site is written in jsp with Oracle. I'd like to use PHP. Do you have any thoughts on this? My recommendation is to utilize the existing skills you have; this echoes Fergus's comment. However, PHP is very popular and if

Re: [PHP-DB] sql injections/best practises

mignon hunter wrote: I'm am trying to find some definitive best practises on database connections with php on both mysql and oracle. I'm starting to redesign a corporate website and am trying to find out more about security and the best practises for database queries and user input form

Re: [PHP-DB] oci driver performance

Chris wrote: Hi all, Using php 5.2.6 + oci driver 1.3.4 from pecl Has anyone had any issues with the oci8 driver performance? I'm doing some profiling using xdebug and all of the time seems to be spent in oci_execute and oci_fetch_array. This shows up when I use jmeter to hit the app

Re: [PHP-DB] Using oci_execute

Walter Galvão wrote: Hi, Im using the oracle instant client basic in my php app, with apache server. When a query returns few rows, there is no problem. Otherwise, the oci_execute method doesn return any records neither errors! How can i solve this problem?? My implementation: function

Re: [PHP-DB] Using oci_execute

Walter Galvão wrote: Are you exceeding the PHP script time out, or exceeding the memory limit? I dont know. Doesnt appear any message. The script prints the last message before the oci_execute call. I'd start by looking at the max_execution_time and memory_limit settings in php.ini.

Re: [PHP-DB] OCI

Daniel Brown wrote: On Mon, Jul 21, 2008 at 12:22 PM, Mad Unix [EMAIL PROTECTED] wrote: How could I build the OCI8 extension module for php5 under CentOS5? I have installe PHP/APACHE/MYSQL through yum install ... OCI8 is a PECL extension. 'pecl install oci8' If you need

Re: [PHP-DB] No resultset with ocibindbyname

) to the former but not the latter. If anyone volunteers to write some test cases I can merge a patch to OCI8 to allow: oci_bind_by_name($s, ':bv', $bv, -1, SQLT_AFC); Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal

Re: [PHP-DB] No resultset with ocibindbyname

projekte_generisch where pid='u0test' PID ANFANG ENDELAENGE u0test utest 8 Hope this helps diagnosting the error. Do other queries with binds work? Is PHP using the correct NLS language configuration? Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog

Re: [PHP-DB] No resultset with ocibindbyname

/tdtdeinepid/td/tr/table (The value is repeated because the array contains numerically and associatively indexed values.) Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com/f8jad -- PHP Database

Re: [PHP-DB] Retreving X, Y, Z from the Geometry column in oracle 10g

on page 141 of the current (1.4) version of http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf Also see the use of SDO_UTIL.GETVERTICES in http://forums.oracle.com/forums/thread.jspa?messageID=1448667#1448667 Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED

Re: [PHP-DB] PHP ORACLE SSL ?

the network listener to get encrypted traffic. Check your license too: the Advanced Security Option (ASO) is probably a separately licensble product. Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com

Re: [PHP-DB] Oracle TNS no listener

. PHP is running on my local box. I've got TNS_ADMIN set as an env variable Any help gratefully received :-) Cheers Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1

Re: [PHP-DB] PHP with a XML database

/) To unsubscribe, visit: http://www.php.net/unsub.php -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP with a XML database

/technology/forums/xml.html The people who monitor those lists are specialists. Chris Ritesh Nadhani wrote: I just checked: http://www.oracle.com/technology/tech/xml/xmldb/index.html Is the solution free or we have to pay license cost? I dont see any information about that. Christopher Jones wrote

Re: [PHP-DB] Building PHP with Oracle support

? -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Apache 2.2 + PHP5.2 + php_oci8.dll

client for linux ( I just wonder why). Thanks. On 12/27/06, Christopher Jones [EMAIL PROTECTED] wrote: PHP's oci8 extension on Windows is now compiled with an Oracle 10g client and depends on new functionality in it. The 10g Oracle Instant Client is freely available (and trivial to install) from

Re: [PHP-DB] My first try with PHP and Oracle ..

of installation documents that show how to configure PHP with oci8 enabled. One is at: http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ -- PHP

Re: [PHP-DB] berkeley db + php + locking

exist within the library.) Thank you for any help you can offer. I have searched the web and the archives of this list but I couldn't find much. -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ -- PHP Database Mailing List (http

Re: [PHP-DB] Problem with executing Oracle query for creating procedure

using PHP string concatenation. Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with Oracle

)'); oci_bind_by_name($s, ':bv', $v, 20, SQLT_CHR); foreach ($a as $v) { $r = oci_execute($s, OCI_DEFAULT); } oci_commit($c); Or explore calling a PL/SQL block and do a bulk FORALL insert. I'll blog about bulk FORALL in a few days. Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED

Re: [PHP-DB] php_oci8.dll

(version 8,9 or 10) on another machine check the steps on using PHP with Oracle Instant Client, this should be easier to work with the the full Oracle client. Chris -- Christopher Jones, Oracle Corporation, Australia. Email: [EMAIL PROTECTED] Tel: +61 3 8616 3622 Blog: http://blogs.oracle.com

Re: [PHP-DB] PHP + OCI en Debian

: --with-oci8 I suspect you'll have to compile php from source, you won't be able to use a package to do this, but I could be wrong. -- Postgresql php tutorials http://www.designmagick.com/ -- Christopher Jones, Oracle Corporation, Australia. Email: [EMAIL PROTECTED] Blog: http

Re: [PHP-DB] Oracle / Random errors

RIOTTEAU Gwénaël wrote: Hi, i try to connect my PHP application with Oracle. But i have some random errors (with the function OCIStmtExecute) : ORA-12152: TNS:unable to send break message ORA-03114: not connected to ORACLE sometimes it works well, sometimes not (for the same query)

Re: [PHP-DB] how to lock multiple row in Oracle Db?

Rasim ÞEN wrote: Hi friends , my code like this $sql=SELECT mid,substr(ROWID,0,100) as nROWID,MEMBER_ID, NAME, SURNAME, E_MAIL, SUBJECT, MAIL_BODY, to_char(DATE_CREATED,'DD.MM. HH24:MI:SS') as DATE_CREATED, RETRY, PRIORITY, E_MAIL_FROM, RECEIVER_MEMBER_ID, RECEIVER_NAME,

Re: [PHP-DB] CLOB-load() error (OCI8 against Oracle 10G )

What line of code is 1546? How are you binding/executing/fetching? Are you using OCI_B_CLOB? If you post a complete (small) testcase we may can look at it. Please include DDL to create any table. Most importantly, use the refactored OCI8 driver: http://pecl.php.net/package/oci8 -- cj

Re: [PHP-DB] PHP CLI OCILOGON - undefined function

Use the phpinfo() function to check that the same php is being used in Apache and on the command line. Make sure LD_LIBRARY_PATH contains $ORACLE_HOME/lib Relink with --with-oci8 Another suggestion is upgrade PHP to 4.4 and manually get the new refactored oci8 drivers. After you upgrade to

Re: [PHP-DB] Can't compile Oracle's 10g support in PHP5

The --with-oracle option is a long deprecated interface to Oracle and no-one has updated the configure script to work with Oracle 10g. Can you use the new --with-oci8 option? Otherwise you'll need to update ext/oracle/config.m4. The code in ext/oci8/config.m4 may help. With either configure

Re: [PHP-DB] php3 and oracle9i client libraries doesn't compile..

neil smith wrote: Hi Martin, It's a legacy application that is huge and sprawling and teh programmers who developed it left along time ago , apparently. It would probably be easier to write a whole new application then convert it to php 4 or 5 and thankfully thats not what I've been asked to

Re: [PHP-DB] php4 can't find tnsnames.ora oracle9 but can connectif description

tnsnames.ora However this is not good, so if you have any other idea please let me know. I'm flumuxed. thanks, neil gt;From: Christopher Jones lt;[EMAIL PROTECTED]gt; gt;To: neil smith lt;[EMAIL PROTECTED]gt; gt;CC: php-db@lists.php.net, [EMAIL PROTECTED] gt;Subject: Re: [PHP-DB] php4 can't find

Re: [PHP-DB] php4 can't find tnsnames.ora oracle9 but can connect if description hardcoded

use tnsnames.ora with sqlplus or tnsping. Does anybody have any ideas what is going wrong? Is this a bug? thanks, neil -- Christopher Jones, Oracle Corporation, Australia. Email: [EMAIL PROTECTED] Tel: +61 3 8616 3622 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Losing the ability to connect to Oracle database

Leo D. Geoffrion wrote: I recently upgraded to PHP5 and now have a curious Oracle problem. The PHP scripts query the database fine. Then overnight, the database shuts down for backup and restarts. The next day, PHP can no longer connect to the database until I restart Apache. Then, it's happy

Re: [PHP-DB] Blob problem (php and oracle)

Here are some things you could try. Remove all the @ suppressions and make sure error_reporting = E_ALL and display_errors = On are set in your php.ini. Echo the SQL statement inside SQLInsertLob() to make sure it is constructed OK. Echo the filename to check it includes the appropriate path. If

Re: [PHP-DB] OCI ignoring NLS_DATE_FORMAT parameter

Doug McMaster wrote: Regardless of how I set the NLS_DATE_FORMAT parameter, when I do a select statement DATE fields are returned in the Oracle default DD-MON-RR format. I can successfully set NLS_DATE_FORMAT using either an environment variable and restarting apache or by using ALTER SESSION

Re: [PHP-DB] ocilogon timeout

Juffermans, Jos wrote: Hi, Some of our scripts that generate customer-facing pages, need a connection to a database. The problems is that the database is in Norway and - allthough we have a VPN setup - the connection isn't always available. In case the connection cannot be made, we can redirect

Re: RE: [PHP-DB] Re: oci8 cannot connect after restarting DB

During my presentation at the PHP Conference in Frankfurt I put out a call for participation in creating a roadmap for Oracle connectivity in PHP. When I get back to work (I'm on a short vacation in Europe with intermittent email access) I'll be following up on this. While I'm away, feel free

Re: [PHP-DB] PHP 4.3.8/Oracle 9i OCI call question for BLOBs

[EMAIL PROTECTED] wrote: I'm trying to write text to a BLOB. I got a valid return code but it did not write the BLOB. I was able to use similar code writing to a CLOB. Any examples I've seen for BLOBs are reading from Binary files. Here's how I did the CLOB, but it would not work for

Re: [PHP-DB] Multiple Oracle connections

Chris Back wrote: Hi, I am hoping that someone can help diagnose this issue. I am able to successfully connect to and query a remote Oracle 9.2 database from apache2/php5. However, when I have multiple clients hitting my php scripts, all of which require a connection to the database, problems

Re: [PHP-DB] How use select for update

Chris wrote: Is row-level locking happening? I think that the lock doesn t work When are you checking the locks? I am checking the lock with an SQLPLUS session If i lock my table with SQLPLUS, PHP can make an select for update But if i try to lock with PHP i can make an other select for update

Re: [PHP-DB] php and oracle

, I won't win the programmers Nobel-Prize for that crap, but it works so far; dropped connections are reconnected. Dieter Christopher Jones sagte: D.Wilkening wrote: Hi everyone, i've a problem using php with oracle 10g. (php 5.0.1 compiled against Oracle 10.1.0.2-libs, apache2 and apache1) One

Re: [PHP-DB] DB Connectivity Problem

Jon Foreman wrote: Does anyone have any suggestions for the following problem: I'm running Apache/1.3.31 and PHP Version 4.3.8 connecting to an Oracle database. Periodically, PHP is unable to connect to the database. When this problem occurs, I am able to connect to the database from the

Re: [PHP-DB] OCI8

It might be a feature of PHP's connection caching. Why don't you log a bug in the PHP bug DB so the problem can be tracked? Do you really need to keep reconnecting? See http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq.html#conmgt Chris yannick wrote: I have some

Re: [PHP-DB] Oracle Client Libraries for Linux

Peter Beckman wrote: How do I get connected from a remote PHP+Apache box to Oracle9i on linux? The current Oracle Instant Client bundle is fine for using PHP on Windows, but does not have headers for compiling PHP with Oracle support on other platforms. An Instant Client SDK with headers is

Re: [PHP-DB] Re: Extremely Urgent: Problem with PHP and Oracle

Justin Patrin wrote: Charles Morris wrote: putenv(ORACLE_SID=PROJ); putenv(ORACLE_HOME=/home/oracle9); I have tried putenv myself and it doesn't seem to work for Oracle connections. Putting those in your shell environment, then restarting apache. Check to see if the env vars are set

Re: [PHP-DB] Oracle syntax

Rafi Sheikh wrote: Hi list. I am a newbie and would like to ask if anyone could give me the proper syntax for connecting with oracle DB. For example with MySQL it is: mysql_connect..., mysql_query... For MS SQL Server: mssql_connect..., mssql_query... There are various examples in the PHP

Re: [PHP-DB] PHP - Calling a Oracle 9i procedure

Joshua, I see this is the question asked on http://forums.oracle.com/forums/thread.jsp?forum=178thread=248354tstart=0trange=15 I'll followup on the OTN forum, not to this PHP-DB mail list. Chris Joshua Skagemo wrote: Hi, I am trying to call a procedure in Oracle 9i but I just can't get it to

Re: [PHP-DB] Error loading module: Unable to load dynamic library

Philippe wrote: Well, the exact message is: Unable to load dynamic library php_oci8.dll: The specified procedure could not be found If I remove the library the message becomes The specified module could not be found. It seems to be able to find the library (all the paths are correct) but it

Re: [PHP-DB] Error loading module: Unable to load dynamic library 'c:\tools\php\extensions\php_oci8.dll' - The specified procedure could not be found

Philippe wrote: Hi, I am experiencing the message in the title of this message when starting or restarting Apache. I have the following configuration: - Windows XP - Apache 2.0.49 - PHP 4.3.6 - Oracle Client 8i If anyone has any information as to why this is happening and how I can solve it, I

Re: [PHP-DB] Error loading module: Unable to load dynamic library

as a database management tool called Aqua Data Studio which uses native connections. Christopher Jones wrote: Philippe wrote: Hi, I am experiencing the message in the title of this message when starting or restarting Apache. I have the following configuration: - Windows XP - Apache 2.0.49 - PHP 4.3.6

Re: [PHP-DB] PHP's Oracle interface

Joseph Burch wrote: Foolks - In building the Apache PHP-Oracle interface we have discovered a discrepancy between the functions listed in the PHP on-line documentation and the function list obtained by nm for libphp4.so. Our UNIX Solaris build comprises Apache_1.3.29, PHP-4.3.4, and the full

Re: [PHP-DB] Re: ocilogon error

Justin Patrin wrote: Adam Williams wrote: Hi, I have oracle and PHP working together on a remote server called zed that runs redhat linux. I have another computer called accessserver that runs win2k pro with PHP that I am trying to connect to oracle on zed. Both computers have the oracle

Re: [PHP-DB] Oracle/PHP Instant-Client ( remote connection )

Comments below. Jim Morrison wrote: Hello all, Hope this isn't an FAQ - have trawled google, otn.oracle, php.net etc - not sure I can find the answer.. I've been using phpmySql for a while now and getting on great - however I'm now tasked with getting my php to talk to a _remote_ ( right next

Re: [PHP-DB] getting BLOBS (ORACLE) back to filesystem

Elke Stahl wrote: i successfully stored blobs in an oracle table via php. but it seems to be impossible getting them back to filesystem! It is a binary (no picture or executable) which arives via mail and is written into a unix-filesystem. ive stored this binary as blob datatype together with

Re: [PHP-DB] PHP5B5 + Oracle9i + Apache1.3

Josef Suchanek wrote: my platform is W2K or WXP. For the first I tried Apache 1.3.22 included in Oracle 9i installation with bad result. Then I tested Apache 1.3.29 with the same bad result. Then I tried IIS without problem and last test was with Apache 2.0.48. It worked fine too. What about

Re: [PHP-DB] PHP oracle 9.2

Delfins wrote: i have successfully installed Oracle 9.2 on Slackware 9.0 database works fine also any other applications runs ok. but when i compiled PHP5 with OCI8 (path i was specified as ORACLE_HOME) but running some scrip, i have this error : Warning: ocilogon(): _oci_open_server: Error

Re: [PHP-DB] Oracle + PHP

Luis Moran Ochoa wrote: I've build the typical script for starting apache, it's like this: $ORACLE_HOME=blablahblah... more oracle variables Are the environment variables exported in the script?: ORACLE_HOME=/my/oracle/home export ORACLE_HOME Are all variables needed set? Are

Re: [PHP-DB] Oracle + PHP

neither. I don't know what more tests to do I check the permissions too They appear to be right. I'm completely lost Christopher Jones wrote: Luis Moran Ochoa wrote: I've build the typical script for starting apache, it's like this: $ORACLE_HOME=blablahblah... more

Re: [PHP-DB] Re: [PHP] Oracle + PHP

What's the exact error you get when you try to connect to oracle and what command are you using to connect? Does a phpinfo() script show the Oracle env vars correctly under the Environment section? Chris Luis Moran Ochoa wrote: These are the exact details... /usr/oracle permissions 750 owner

Re: [PHP-DB] PHP 4.3.4 ADODB Oracle 9.2

William Cheung wrote: All the system errors are solved. However, the query seems not returning any rows. I got undefined index error on any query returns. Am I hitting the brick wall? Do PHP and ADODB work with Oracle 9.2? Are there anyone know the answer? I am using Windows 2K, IIS and

Re: [PHP-DB] PHP 4.3.4, ADODB and Oracle9.2

William Cheung wrote: Win 2K server IIS 4.0 PHP 4.3.4 ADODB 4.10 Oracle 9.2 I got the following error Warning: ociplogon():_oci_open_server: Error while trying to retrieve text for error ORA-12538 in C:\PHPRoot\ADODB\drivers\adodb-oci8.inc.php on line 128 You might be hitting a combination

Re: [PHP-DB] Stored Procedures ?

Ricardo Lopes wrote: Is possible to call database stored procedures from php with oracle or any other db? There is a complete Oracle example in Frank Naudé's Oracle/PHP FAQ: http://otn.oracle.com/tech/opensource/php_faq.html#PROC Chris -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] connect nativly with Oracle9i

nabil wrote: I have php 4.3.4 on windows as a development environments, i could not connect to oracle using the native functions, What error do you get? should i connect using ODBC ?? OCI8 has some benefits, depending on what you want to do now and/or in the future. What are you trying to

Re: [PHP-DB] oracle compilation with php

I see the answer has already been given on php-install. A suggestion which hasn't been made is to use PHP's new oci8 interface in preference to the old one called oracle whenever possible. To quote from a note on Oracle's PHP forum (see http://forums.oracle.com/forums/forum.jsp?forum=178 )

Re: [PHP-DB] oracle compilation with php

Douglas, To try and reduce confusion, a Client install refers to the option of that name in the Oracle9i Database Release installer. (The other options are Database, Mgt Intg, and Cluster Mgt). This will install the headers needed to link PHP, if your previous installer choice didn't load them.

  1   2   >