On Mon, Jul 07, 2003 at 03:58:45PM -0400, Reuben D. Budiardja wrote:
Apparently there is a bug or something with OCI8 extention for PHP-4.3.2.
Using the same configuration and everything, I compiled PHP-4.3.1, and 4.2.3
and both worked.
I send e-mail to PHP-DEV wondering if this is a
On Wed, Feb 12, 2003 at 07:43:48PM +1100, Steve Farmer wrote:
Hi all,
We recently upgraded to php 4.30 and now our oracle errors are not
returning.. This used to work
$errmsg = ocierror($err_curs);
ocirollback($err_conn);
$errtext =
(http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Thies C. Arntzen - Looking for all sorts of freelance work - just ask..
http://www.amazon.de/exec/obidos/wishlist/AB9DY62QWDSZ
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
On Tue, Oct 15, 2002 at 03:10:20PM +0200, [EMAIL PROTECTED] wrote:
Hi everybody,
I have set up a connection to an Oracle database using OCILogon. In general that
works, but frequently (without a clear pattern) it does not.
I know that the performance of the network is variying very much
hi,
seems like oreilley will cancel my tutorial about PHP and
Oracle at OSCON in san diego as there are not enough ppls
interested.
so - if you go to oscon, and if you are interested in that
subject _and_ if you have not decided to sign up for my
tutorial - hurry up
On Wed, May 01, 2002 at 12:35:48PM +0100, Ford, Mike [LSS] wrote:
Using the Oracle OCI interface, as far as I can see if I do the following:
$stmt = OCIParse($conn, 'DELETE FROM TITLES'
. ' WHERE TAG0'
. ' RETURNING
On Wed, Apr 17, 2002 at 01:03:49PM -0500, Pedro Garre wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,
OCIRowCount does not seem to work when inserts are made in a block:
BEGIN insert ...; insert ...; insert ...; END;
It returns 1, but 3 rows have
On Tue, Apr 16, 2002 at 06:28:19PM +0200, [EMAIL PROTECTED] wrote:
Put this on your php page
Putenv(ORACLE_HOME=/home/oracle/8.0.5);
Putenv(LD_LIBRARY_PATH=/home/oracle/8.0.5/lib);
Putenv(TWO_TASK=WAGNER_PC);
no. do not use PutEnv or SetEnv in httpd.conf!
please set _ALL_ needed
On Thu, Apr 11, 2002 at 06:09:02PM +0800, John Lim wrote:
Hmm, I have also been having similar problems with LOBs. However it might
not
be cursor_sharing=force, because on my Win 2000 oracle, LOBs work fine with
PHP
with this parameter set.
However on our Sun server, PHP crashes as you
On Fri, Apr 05, 2002 at 01:08:20PM +0100, Chris Andrew wrote:
Hi,
Please tell me this is possible:
I have a bunch of stored queries on an Oracle machine. Using PHP from a
separate RedHat box, I want to run these stored queries.
My PHP is compiled with oracle support, and I can issue
On Wed, Mar 06, 2002 at 10:59:33PM +0500, Mohammad Saad wrote:
Hello
I have PHP4.10 on solaris with oci8 support. everything seems to work
well. Oracle support is working fine. but I am getting an error when I
am trying OCIBindByName to bind a variable to an out variable of a
stored
On Sat, Feb 09, 2002 at 01:10:58PM +0100, Jaros?aw Jankowski wrote:
Theodore D Boardman wrote:
Greetings!
As far as I can tell from the documentation, the OCI8 driver supports Oracle
8. However, on the ADODB site, they mention that the OCI8 driver supports
Oracle 8/9.
Can
On Thu, Jan 17, 2002 at 01:20:47PM -0700, Randall Barber wrote:
I've been using the OCI8 extension and have a question about the Persistent
Connections.
While debugging the site, I will run into the following error (paraphrased):
BeginSession: too many processes running
etc...
I
On Mon, Dec 03, 2001 at 10:16:13PM -0800, John Kolvereid wrote:
Hi,
Me again, My table has a CLOB in it. Could that be a problem. When
I tried the same querry on another table w/o a CLOB it succeeded. Please
advise. Thanks.
CLOBS were indroduced in oracle8 you need to use the
On Mon, Dec 03, 2001 at 06:58:00AM -0800, John Kolvereid wrote:
Hi,
I have just downloaded and installed PHP4.0.6. I have configured it
--with-mysql and --with-oracle. I am able to easily use Mysql but NOT
Oracle. When I try an ora_logon or ora_login I get 'Fatal error: Call
to
hi,
i'm working on OUT paramter support in the ODBC module when
calling stored procedures. to start playing with it i need to
create a stored procedure in DB2 (this is the db my customer
is using). me -the stupid oracle guy- does not know how to
load a stored procedure
On Mon, Sep 10, 2001 at 03:50:08PM +0200, Ez-Berlin, E2boxb wrote:
hi list,
read my paper from conf.php.net/oci - it should explain all
that!
tc
I'm using PHP 4.0.6 and i want to give an array as parameter
from a php script to an oracle pl/sql - procedure...
We had an older
On Tue, Sep 04, 2001 at 07:44:42AM -0800, [EMAIL PROTECTED] wrote:
Hello everyboby!
this is my first time on this list and I writing to ask for help on SP.
I have the following code calling a Procedure:
?
$c=OCILogon(SYSTEM,manager);
$x =0;
$cpf=10001628852;
$sth =
On Wed, Sep 05, 2001 at 10:24:28AM -0500, Brian Mauter wrote:
Are you running out of logons? You should only need the client
libraries on
the machine with the PHP pages. You do not need them anywhere else.
(That's the beauty of the web!)
Make sure you have ocilogoff in your PHP page when
On 17 Aug 2001 19:41:26 +0200, Konrad BüKo wrote:
Hi
We've a Problem with PHP4 OCIFetch and varchar2 !
OCHIFetch with number or date Field it work's fine but when i'll fetch a
varchar2 Field then i've no output in the browser !
When i dump the array then i see the character is 20 Bytes
On Thu, Jul 26, 2001 at 01:17:57PM -0500, Lee Whatley (System
Admin) wrote:
Well I found out that the reason I got the error message was
that the
--with-oci8 option was looking for libclntsh.so.8.0
I made a symlink of this which pointed to the libclntsh.so.9.0 that
comes with oracle 9i.
On Thu, Jul 26, 2001 at 01:50:37PM -0500, Lee Whatley (System
Admin) wrote:
Well, I was able to modify the main configure script and the
configure.m4 script in the ext/oci8 directory to detect 9i, and doing so
allowed the configure process to complete and php to compile. When I
did a
On Thu, Jul 26, 2001 at 04:57:29PM -0500, Lee Whatley (System
Admin) wrote:
Here is a patch that will allow configure to properly detect
oracle 9i
If your mail server filters out attachments you can download it from
http://www.cba.ua.edu/~spaff/php-4.0.6-oci8-oracle9i.patch
The patch
On Thu, Jul 05, 2001 at 04:40:09PM +0900, Michael Cheung wrote:
Hi;
Linux 2.2.18 + oracle 8.1.7i + php 4.0.5 + oci8
I got a warning in log file.
PHP Warning: failed to rollback outstanding transactions!
I have simplify the script.
it will cause the warning.
function
On Tue, May 22, 2001 at 09:03:45PM +0200, snpe wrote:
-- Forwarded Message --
Subject: Re: [PHP-DB] OCIFetch performance problem with more rows
Date: Tue, 22 May 2001 21:02:42 +0200
From: snpe [EMAIL PROTECTED]
To: Brian S. Dunworth [EMAIL PROTECTED]
On Tuesday 22
On Wed, May 23, 2001 at 12:21:08PM +0200, Remigiusz Sokolowski wrote:
Hello,
I have performance problem with OCIFetch (and OCIFetchInto, too)
when query return more rows.Same query from sqlplus is more fastest (more
rows is worse then less rows)
Are the
On Tue, May 22, 2001 at 09:41:25AM +0900, Michael Cheung wrote:
On Mon, 21 May 2001 16:39:05 +0200
Thies C. Arntzen [EMAIL PROTECTED] wrote:
On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote:
Hi;
Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface.
I
On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote:
Hi;
Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface.
I use the following lines to get a result from database;
But It give me result 0, it is incorrect;
$sql=Select count(*) From member where
On Mon, May 14, 2001 at 02:19:42PM +0200, jarek wrote:
Hi,
try this:
http://php.weblogs.com/ADODB
the PEAR db-abstraction also supports oracle as a database!
tc
Jarek
Neil wrote:
Hi All
I want to build a site using classes and was wondering is there an Oracle
On Mon, May 14, 2001 at 02:52:01PM +0200, Robert Boehrs wrote:
Hi,
i've just made some simple test with oracle and stored procedures. I've used
a simple select-statement within the stored procedure and the same query for
a direct query within php.
The direct query was about 50% faster. Is
On Fri, May 04, 2001 at 03:50:34PM +0200, Stefan Fokuhl wrote:
Hello,
I do have a little tiny problem with the character set.
If I try to insert a word containing an german umlaut by a php-script,
Oracle strips the seventh bit. I.e. ä becomes a d. In PHP the SQL
statement is written
On Thu, Apr 05, 2001 at 12:47:37PM -0400, Joe Brown wrote:
Don't have a whole lot of practice with the OCIBindByName function, but I
seem to be having success within a recursive select statement.
I'm not useing the operator in my implementation. Don't know if that's a
good or a bad thing
On Mon, Mar 19, 2001 at 01:19:44PM +1030, Andrew Halliday wrote:
Can PHP for Oracle randomly access rows in a result set?
I have read documentation for both Oracle functions (ora_*) and Oracle 8
functions (OCI_*) but cant seem to find a way to randomly access rows in a
result set like you
On Thu, Feb 15, 2001 at 10:07:23AM -0500, Brian Lalor wrote:
On Thu, 15 Feb 2001, Thies C. Arntzen wrote:
how should it?
you would have to pass in the correct statement|connection
handle - elsewise it simply won't work!
Ok, that was a cobbled-up code snippet; replace
resend cause of type in adress
- Forwarded message from "Thies C. Arntzen" [EMAIL PROTECTED] -
Date: Sun, 18 Feb 2001 17:26:25 +0100
From: "Thies C. Arntzen" [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subj
On Wed, Feb 14, 2001 at 05:40:02PM -0500, Brian Lalor wrote:
Good afternoon, all. Sorry if this has been covered before, but a search
of the archives doesn't turn up any relevant answers.
I'm having a problem with the OCI8 commands. I'm using PHP 4.0.4pl1 with
Oracle 8.0.5 (yes, I know
On Thu, Feb 14, 2002 at 04:23:23PM +0100, dsi safir wrote:
Ok, thanks all for the advices.
The problem is linked with the NLS parameters.
Here are my database related param:
NLS_LANGUAGE=French
NLS_TERRITORY=France
NLS_DATE_LANGUAGE= french
NLS_DATE_FORMAT = dd/mm/
set
On Tue, Jan 23, 2001 at 04:57:02PM +0800, Koala wrote:
Here is the code:
$arr_var = Array();
$arr_var[] = Array("KEY"='rec_id', "VALUE"='00', "LENGTH"=-1);\
..
$stmt = OCIParse('DECLARE rec_id NUMBER(20); SELECT recNum INTO rec_id FROM
table WHERE recNum= 2 ');
..
$num_rows =
38 matches
Mail list logo
