[PHP] Windows + php + oracle PL/SQL = ORA-06550

2008-03-13 Thread Martin Jerga
Hello everyone, I just installed Zend Core 2.5.0 (simply apache + php 5) with oracle instant client. I enabled the oracle extension. Everything works ok, but I ran into one strange problem. I can connect to the oracle server without problems, I can also perform SELECTs,INSERTs, etc. The problem

Re: [PHP] PHP Oracle Ebook Request.

2007-10-23 Thread Nathan Nobbe
On 10/23/07, Daevid Vincent <[EMAIL PROTECTED]> wrote: > > I have a garage full of paper books/manuals that I have no idea WTF to do > with because they're all outdated and the recycle people won't take them > b/c > it's too heavy in the blue bin. maybe you could put them in there a few at a time

RE: [PHP] PHP Oracle Ebook Request.

2007-10-23 Thread Daevid Vincent
> -Original Message- > Please include the list in replies. > > > Thanks for your message, With regard to your message, the > main reason > > why I want it Electronically is because, Am a PHP Student > Who has no > > enough Cash to buy from Amazon or any bookseller and more > over,

RE: [PHP] PHP Oracle Ebook Request.

2007-10-23 Thread Daevid Vincent
> -Original Message- > > > Please I need a book called : "Oracle Database 10g > Express Edition PHP Web Programming (Osborne Oracle Press > Series): Books: by Michael McLaughlin". > > > > > > Please if anyone with the E-Book Version of it should > be contact me on my Email > >

Re: [PHP] PHP Oracle Ebook Request.

2007-10-23 Thread Stut
Please include the list in replies. Dare Williams wrote: Dear Stut, Thanks for your message, With regard to your message, the main reason why I want it Electronically is because, Am a PHP Student Who has no enough Cash to buy from Amazon or any bookseller and more over, the book is not avai

Re: [PHP] PHP Oracle Ebook Request.

2007-10-23 Thread Robert Cummings
On Tue, 2007-10-23 at 20:34 +0100, Stut wrote: > Dare Williams wrote: > > Dear Pals, > > > > Please I need a book called : "Oracle Database 10g Express Edition PHP > > Web Programming (Osborne Oracle Press Series): Books: by Michael > > McLaughlin". > > > > Please if anyone with the E

Re: [PHP] PHP Oracle Ebook Request.

2007-10-23 Thread Stut
Dare Williams wrote: Dear Pals, Please I need a book called : "Oracle Database 10g Express Edition PHP Web Programming (Osborne Oracle Press Series): Books: by Michael McLaughlin". Please if anyone with the E-Book Version of it should be contact me on my Email ([EMAIL PROTECTED]).

[PHP] PHP Oracle Ebook Request.

2007-10-23 Thread Dare Williams
Dear Pals, Please I need a book called : "Oracle Database 10g Express Edition PHP Web Programming (Osborne Oracle Press Series): Books: by Michael McLaughlin". Please if anyone with the E-Book Version of it should be contact me on my Email ([EMAIL PROTECTED]). NOTE: I would p

[PHP] oracle instantclient 10 problem

2007-08-21 Thread Rainhard
Ehlo, I compiled php-5.2.3 with the "--with-oci8=instantclient,/opt/instantclient_10_2/" switch and it completed with no errors. First it seems to work well, but now, sometimes i get the infamous - OCIEnvNlsCreate() failed check LD_LIBRARY_PATH - error. The funny thing is, those variables are all

Re: [PHP] Oracle XMLTYPE column truncates

2007-03-13 Thread Mikey
Richard Lynch wrote: DB truncation could be either of the following: #1. The column is not large enough to hold that data. Research LONGTEXT and BLOB #2. The query buffer is not large enough to pass the data in. Re-configure your db/php setup. It was definitely to do with casting it to a CLOB

Re: [PHP] Oracle XMLTYPE column truncates

2007-03-12 Thread Richard Lynch
DB truncation could be either of the following: #1. The column is not large enough to hold that data. Research LONGTEXT and BLOB #2. The query buffer is not large enough to pass the data in. Re-configure your db/php setup. Note that cramming all that XML into the DB seems kinda silly to me, unl

[PHP] Oracle XMLTYPE column truncates

2007-03-08 Thread Mikey
Hi! I am running some tests for implementing variable metadata using Oracle's XMLTYPE. Creating the XML and inserting it into the database works fine, however when trying to retrieve data it truncates the returned results. The code I am using to fetch the data is as follows: $row_sql = "SE

Re: [PHP] Oracle Execute Function

2007-01-18 Thread Chris
Brad Bonkoski wrote: Brad Bonkoski wrote: Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2007-01-18 11:46:10 -0500: Hello All, I have this Oracle function, and within my code I call it like this: $sql = "BEGIN :result := my_funtion_name('$parm1', $parm2, null, null, null); END;"; $s

Re: [PHP] Oracle Execute Function

2007-01-18 Thread Brad Bonkoski
Brad Bonkoski wrote: Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2007-01-18 11:46:10 -0500: Hello All, I have this Oracle function, and within my code I call it like this: $sql = "BEGIN :result := my_funtion_name('$parm1', $parm2, null, null, null); END;"; $stmt = $db->parse($sql)

Re: [PHP] Oracle Execute Function

2007-01-18 Thread Brad Bonkoski
Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2007-01-18 11:46:10 -0500: Hello All, I have this Oracle function, and within my code I call it like this: $sql = "BEGIN :result := my_funtion_name('$parm1', $parm2, null, null, null); END;"; $stmt = $db->parse($sql); $rc = null;

Re: [PHP] Oracle Execute Function

2007-01-18 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2007-01-18 11:46:10 -0500: > Hello All, > > I have this Oracle function, and within my code I call it like this: > > $sql = "BEGIN :result := my_funtion_name('$parm1', $parm2, null, null, > null); END;"; >$stmt = $db->parse($sql); >$rc = null; >ocibi

[PHP] Oracle Execute Function

2007-01-18 Thread Brad Bonkoski
Hello All, I have this Oracle function, and within my code I call it like this: $sql = "BEGIN :result := my_funtion_name('$parm1', $parm2, null, null, null); END;"; $stmt = $db->parse($sql); $rc = null; ocibindbyname($stmt, ":result", &$rc); $db->execute($stmt, $sql

RE: [PHP] Oracle Commits SOLVED

2006-06-22 Thread Jay Blanchard
[snip] did the execute actually succeed? does the data get into the DB if you use OCI_COMMIT_ON_SUCCESS instead of OCI_DEFAULT? I don't support using oci_internal_debug() gives you any extra info? [/snip] I finally did an oci_bind_by_name and then performed the commit. It worked. Oci_internal_de

Re: [PHP] Oracle Commits

2006-06-22 Thread Jochem Maas
Jay Blanchard wrote: > Good afternoon and salutations denizens of the greatest list generated > by electrons! > > I have a situation where I am trying to commit a transaction in Oracle > with PHP as follows; > > $udGeocode = oci_parse($conn, "UPDATE CONT_ADDRESS SET GEOCODE = > '".$geocode[0]."'

[PHP] Oracle Commits

2006-06-22 Thread Jay Blanchard
Good afternoon and salutations denizens of the greatest list generated by electrons! I have a situation where I am trying to commit a transaction in Oracle with PHP as follows; $udGeocode = oci_parse($conn, "UPDATE CONT_ADDRESS SET GEOCODE = '".$geocode[0]."' WHERE CONTRACT_ID = '".$row[0]."' AND

Re: [PHP] Bug Apache/PHP/Oracle on Debian

2006-04-06 Thread Chris
David BERCOT wrote: Hi, I have a server with Apache 2, PHP 5.1.1 and Oracle Instant Client 10.2.0.1. As I have a little bug [http://bugs.php.net/bug.php?id=29779], I've tried the solution (in oci8.c) and recompiled ! But then, everything was broken. So, I get the source of PHP 5.1.2 and recompil

[PHP] Bug Apache/PHP/Oracle on Debian

2006-04-06 Thread David BERCOT
Hi, I have a server with Apache 2, PHP 5.1.1 and Oracle Instant Client 10.2.0.1. As I have a little bug [http://bugs.php.net/bug.php?id=29779], I've tried the solution (in oci8.c) and recompiled ! But then, everything was broken. So, I get the source of PHP 5.1.2 and recompiled again. Everything s

RE: [PHP] Oracle stored procedures

2006-04-06 Thread Jay Blanchard
[snip] I am using PHP with Oracle, but not executing stored procedures. I assume you are already validating the contents of the $addr variable before you bind it? Otherwise, no real ideas here... [/snip] Yes, I am validating the contents of the variable. I have ton some reading, but details a

Re: [PHP] Oracle stored procedures

2006-04-06 Thread Brad Bonkoski
ies of Oracle, could you sooth my aching head and help me to understand what is going on here? I have RTFM and the following article from the PHP Oracle Cookbook; http://www.oracle.com/technology/pub/articles/oracle_php_cookbook/fuecks _sps.html ;and I still am clueless. Thanks a million in advan

RE: [PHP] Oracle stored procedures

2006-04-06 Thread Jay Blanchard
in /home/foo/bar/glorp.php on line 25 If anyone on the list understands the intricacies of Oracle, could you sooth my aching head and help me to understand what is going on here? I have RTFM and the following article from the PHP Oracle Cookbook; http://www.oracle.com/technology/pub/articles/oracle_php_

[PHP] Oracle stored procedures

2006-04-05 Thread Jay Blanchard
ne 1 in /home/foo/bar/glorp.php on line 25 If anyone on the list understands the intricacies of Oracle, could you sooth my aching head and help me to understand what is going on here? I have RTFM and the following article from the PHP Oracle Cookbook; http://www.oracle.com/technology/pub/art

Re: [PHP] PHP/Oracle : bug with accent...

2006-03-15 Thread David BERCOT
> > I have a big problem with my Debian server (Apache 2, PHP 5, Oracle > > Instant Client). I've modified the environment variable NLS_LANG and, > > with SQL*Plus, everything is ok ! But, in a PHP page, I can't insert a > > value with accent (ex: Irène). I can read data with accent, but not > > in

Re: [PHP] PHP/Oracle : bug with accent...

2006-03-15 Thread Burhan
David BERCOT wrote: Hi, I have a big problem with my Debian server (Apache 2, PHP 5, Oracle Instant Client). I've modified the environment variable NLS_LANG and, with SQL*Plus, everything is ok ! But, in a PHP page, I can't insert a value with accent (ex: Irène). I can read data with accent, but

[PHP] PHP/Oracle : bug with accent...

2006-03-14 Thread David BERCOT
Hi, I have a big problem with my Debian server (Apache 2, PHP 5, Oracle Instant Client). I've modified the environment variable NLS_LANG and, with SQL*Plus, everything is ok ! But, in a PHP page, I can't insert a value with accent (ex: Irène). I can read data with accent, but not inserting !!! I s

Re: [PHP] Oracle buying out Zend ... how does that affect PHP?

2006-02-11 Thread Kevin Kinsey
uicy to the big players", as a friend of mine says. Makes you wonder if this really isn't a jab against the other DB companies/orgs --- I could foresee Zend pushing some PHP/Oracle interface/optimization products within a year or so if this happens Kevin Kinsey -- Reality -- what a con

[PHP] Oracle buying out Zend ... how does that affect PHP?

2006-02-10 Thread Marc G. Fournier
http://www.businessweek.com/technology/content/feb2006/tc20060209_810527.htm "Also in Oracle's crosshairs: closely held Zend, based in Cupertino, Calif. Zend's PHP software language is one of the most prevalent on the Web, present in more than 18 million Web sites. The company, which snared h

Re: [PHP] Oracle Question

2005-08-11 Thread Joseph Oaks
xfedex, yes you can connect to a remote Oracle DB, I'm doing for an app I'm trying to write. You have to configure php with the oracle version you have, more than likely with the --with-oci8=/u1/oracle/product/10g line, of course your oracle location will differ. I chose to use the PEAR::DB to do

Re: [PHP] Oracle Question

2005-08-11 Thread tg-php
Yeah, you can connect to Oracle remotely. The standard PHP functions should do it probably, but I've done it using ADODB. I don't know if this is the same on a *nix box, but I was running PHP on a Windows box and needed special Oracle stuff installed on my machine to connect to the Oracle DB.

[PHP] Oracle Question

2005-08-11 Thread xfedex
Hi, Can PHP connect to a remote Oracle db? Because all oracle connecting functions only require 'user' and 'pass' http://us3.php.net/manual/en/function.oci-connect.php http://us3.php.net/manual/en/function.ora-plogon.php Thanks, Regards, pancarne. -- PHP General Mailing List (http://www.php.net

RE: [PHP] Oracle Interface

2005-07-12 Thread Ford, Mike
Hi guys!! I'm just getting back into harness after 4 months off work following major surgery, so I'm well behind on all the PHP groups. It's nice to be back! Forgive me for responding to this one over a month later, but I haven't seen anybody else pointing this out: On 13 June 2005 13:30, Shan

Re: [PHP] PHP+Oracle or PL/SQL Web Application - which one is efficient?

2005-07-04 Thread Richard Lynch
On Mon, July 4, 2005 6:36 am, Rasim SEN said: > I need an advice about PHP+Oracle or PL/SQL Web Application. > > We are using at the moment PL/SQL Web Application for our all pages. But > some of my friends says that php+oracle more effiecient than pl/sql. > > Does anybody

[PHP] PHP+Oracle or PL/SQL Web Application - which one is efficient?

2005-07-04 Thread Rasim SEN
Hi friends, I need an advice about PHP+Oracle or PL/SQL Web Application. We are using at the moment PL/SQL Web Application for our all pages. But some of my friends says that php+oracle more effiecient than pl/sql. Does anybody have exprience or statistical data about this. Or how can we

Re: [PHP] Oracle Interface

2005-06-13 Thread Shane Presley
On 6/13/05, Jay Blanchard <[EMAIL PROTECTED]> wrote: > To find out how your PHP was compiled create a test page with this > only... > > > phpinfo(); > > ?> > > And then load the page from your web server. It will return a wealth of > information to you. As far as Oracle compatability it would

RE: [PHP] Oracle Interface

2005-06-13 Thread Jay Blanchard
[snip] How do I find out how my PHP was compiled? The documentation states: You have to compile PHP with the option --with-oracle[=DIR], where DIR defaults to your environment variable ORACLE_HOME. But I'm using PHP from the Red Hat default install (I didn't compile it). Also, do you know if th

Re: [PHP] Oracle Interface

2005-06-13 Thread Shane Presley
On 6/10/05, Richard Lynch <[EMAIL PROTECTED]> wrote: > On Fri, June 10, 2005 8:48 am, Shane Presley said: > > Where can I find some info on integrating Oracle and PHP? > > http://php.net/oracle > > pretty much covers it. Thanks! You're right, that looks pretty straight forward. Although I do h

Re: [PHP] Oracle Interface

2005-06-10 Thread Richard Lynch
On Fri, June 10, 2005 8:48 am, Shane Presley said: > Where can I find some info on integrating Oracle and PHP? http://php.net/oracle pretty much covers it. > I had some PHP front ends to a MySQL database, worked great. Our DBAs > want to change the back end from MySQL to Oracle 10g. How hard w

Re: [PHP] Oracle Interface

2005-06-10 Thread Webmaster
Shane Presley wrote: Where can I find some info on integrating Oracle and PHP? I had some PHP front ends to a MySQL database, worked great. Our DBAs want to change the back end from MySQL to Oracle 10g. How hard would it be to convert my PHP scripts, and where would I go to read up on Oracle

RE: [PHP] Oracle Interface

2005-06-10 Thread Jay Blanchard
[snip] Where can I find some info on integrating Oracle and PHP? I had some PHP front ends to a MySQL database, worked great. Our DBAs want to change the back end from MySQL to Oracle 10g. How hard would it be to convert my PHP scripts, and where would I go to read up on Oracle <--> PHP? [/snip]

[PHP] Oracle Interface

2005-06-10 Thread Shane Presley
Where can I find some info on integrating Oracle and PHP? I had some PHP front ends to a MySQL database, worked great. Our DBAs want to change the back end from MySQL to Oracle 10g. How hard would it be to convert my PHP scripts, and where would I go to read up on Oracle <--> PHP? Thanks Shane

[PHP] Oracle rpm?

2005-03-28 Thread D A GERM
Is there an rpm to install the oracle compnents for version 4.3.4 php? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PHP+Oracle+Apache

2004-11-14 Thread Evgeniy Sudyr
Good day, I use Apache2+PHP5+Oracle8 under WindowsXP & I want use php with Oracle. I uncommented strings in php.ini: ;extension=php_oci8.dll ;extension=php_oracle.dll ;extension=php_dbase.dll Now when I start apache it say me that this extensions are not present in extensions dir (But they are e

[PHP] Oracle Connection

2004-10-18 Thread Syed
Hi All, (B (Bwill anybody tell me how to connect oracle database using php script. (B (BThanx (B (BSyed

[PHP] Oracle statement handles... or resources in general

2004-09-23 Thread Mikey
Hi NG! Consider the following piece of (simplified) code: $sql = "SELECT * FROM table"; $sth = ociparse ($conn, $sql); ociexecute ($sth); $sql = "SELECT * FROM table2"; $sth = ociparse ($conn, $sql); ociexecute ($sth); I have just been reading an article on php|arch that states that each open st

RE: [PHP] Oracle 8 functions

2004-05-05 Thread Fidencio Monroy
Thanks, i catch the prob, after ociparse(), using ocifetchinto, the indexes in the array are generated as UPPERCASE... -Original Message- From: Fidencio Monroy [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 2:08 PM To: (PHP General List) Subject: [PHP] Oracle 8 functions Hi, im

[PHP] Oracle 8 functions

2004-05-05 Thread Fidencio Monroy
Hi, im trying to use ora8 functions, and i have some trouble, the documentation is a reference not a guide, so probably im skipping some steps. to connect ocilogon() is used, and the connection establishes, this is verified checking the resurce returned. then i do an ociparse() with a select st

[PHP] Oracle 8i -- execution stops

2004-03-23 Thread Matthew Hillebrand
When I make a complex query to a table with 500,000 rows via PHP, my web browser thinks for a minute and then stops the execution of the script with no error messages at all. I have set the max_execution_time to 400 and called error_reporting(E_ALL) with the same results. I'm using PHP 4.3.1 an

[PHP] PHP + Oracle and UK locale

2004-02-16 Thread Harry Sufehmi
(Redirected by "Harry Sufehmi" <[EMAIL PROTECTED]>) First sorry if this email was already received by you, I sent this originally on the weekend but didn't seem to be showing up in the list, so trying to repost again today. I've setup phpBB in my company using Oracle as its backend. Everyone's h

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

2004-02-04 Thread Luis Moran Ochoa
IT WORKS. Exactly, I need to unset the locale variables With that It works without problems. Thank you all. in the start script to see which variables are set. Boot, move /tmp/apache-start to /tmp/apache-boot, stop apache, start apache from your root shell. "diff -u /tmp/apache-boot /tmp/ap

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

2004-02-02 Thread Luis Moran Ochoa
Ok, thanks I will try it. Michael Mauch wrote: Luis Moran Ochoa wrote: ORACLE_SID=OWEB ;export ORACLE_SID; ORACLE_HOME=/usr/oracle/product; export ORACLE_HOME; TNS_ADMIN=/usr/oracle/product/network/admin; export TNS_ADMIN; ORACLE_BASE=/usr/oracle; e

Re: [PHP] Oracle + PHP

2004-01-30 Thread Michael Mauch
Luis Moran Ochoa wrote: > ORACLE_SID=OWEB ;export ORACLE_SID; > ORACLE_HOME=/usr/oracle/product; export ORACLE_HOME; > TNS_ADMIN=/usr/oracle/product/network/admin; export TNS_ADMIN; > ORACLE_BASE=/usr/oracle; export ORACLE_BASE; > ORA_NLS33=/usr/oracle/product/oc

Re: [PHP] Oracle + PHP

2004-01-29 Thread Luis Moran Ochoa
e instance that is serving that request dies, raise an error that says something like "Couldn't connect to database" and no more php+oracle pages can be requested... But php and apache still works. If I stop apache and launch it again from console using /etc/init.d/apache start.

[PHP] Oracle + PHP

2004-01-29 Thread Luis Moran Ochoa
u request a php page that connects to oracle Then the instance that is serving that request dies, raise an error that says something like "Couldn't connect to database" and no more php+oracle pages can be requested... But php and apache still works. If I stop apache and laun

Re: [PHP] PHP - Oracle - BLOBs - Display BLOB data in a table

2003-12-03 Thread Justin Patrin
Actually, I would suggest using two scripts. The first takes the id of the row as a GET parameter (say $id) and grabs the image data, sends the header, and echoes the data. The second script outputs a web page with an img tag. As such: image.php page.php Image.jpg Chris W. Parker wrote:

RE: [PHP] PHP - Oracle - BLOBs - Display BLOB data in a table

2003-12-03 Thread Chris
: Ahbaid Gaffoor [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 2:46 PM To: PHP General Mailing List Subject: [PHP] PHP - Oracle - BLOBs - Display BLOB data in a table I have written the first half of my application which stores images in BLOB fields of an oracle database. This part of my

RE: [PHP] PHP - Oracle - BLOBs - Display BLOB data in a table

2003-12-03 Thread Chris W. Parker
Ahbaid Gaffoor on Wednesday, December 03, 2003 2:46 PM said: > I have written the first half of my application which stores images in > BLOB fields of an oracle database. > > This part of my app. works fine. > > I am now trying to download the database stored blob

[PHP] PHP - Oracle - BLOBs - Display BLOB data in a table

2003-12-03 Thread Ahbaid Gaffoor
I have written the first half of my application which stores images in BLOB fields of an oracle database. This part of my app. works fine. I am now trying to download the database stored blob and display it in my web page. I am able to get the blob data into a variable called $blobdata. If I

[PHP] Oracle 9iAS - Add PHP module

2003-11-15 Thread Ahbaid Gaffoor
I'm running Oracle 9iAS on Linux, does anyone know if it's possible to add PHP to it as a module? Given that it's based on Apache? are there any docs out there on how to do this? thanks Ahbaid -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.ph

Re: [PHP] Oracle - Win32

2003-10-12 Thread Paul Gregg
In mail.php.general, imran <[EMAIL PROTECTED]> wrote: [snip] > format like such: php_xxx. For Oracle DD, you'll need php_oracle.dll. Take > the oracle dll. Only use the oracle dll if you are using oracle 7 client libs. If you are using Oracle 8+ then you want the oci8 dll. Do not copy the php_o

Re: [PHP] Oracle - Win32

2003-10-10 Thread imran
like this: ;extension=php_xxx1.dll ;extension=php_xxx2.dll un-comment this line for oracle dll... THAT's it! Save the php.ini. Now you can call Oracle functions - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 11, 2003 10:

Re: [PHP] Oracle - Win32

2003-10-10 Thread John Nichel
[EMAIL PROTECTED] wrote: Hello mailing list, I want to use Oracle function in PHP parser in Win32 OS, but I don't know how to install it, in the official documentation tell this: Installation You have to compile PHP with the option --with-oracle[=DIR], where DIR defaults to your environmment vari

[PHP] Oracle - Win32

2003-10-10 Thread orlandopozo
> > Hello mailing list, I want to use Oracle function in PHP parser in Win32 > OS, > > but I don't know how to install it, in the official documentation tell > this: > > > > Installation > > You have to compile PHP with the option --with-oracle[=DIR], where DIR > > defaults to your environmment va

Re: [PHP] Oracle - Win32

2003-10-10 Thread orlandopozo
> Hello mailing list, I want to use Oracle function in PHP parser in Win32 OS, > but I don't know how to install it, in the official documentation tell this: > > Installation > You have to compile PHP with the option --with-oracle[=DIR], where DIR > defaults to your environmment variable ORACLE_HO

[PHP] Oracle - Win32

2003-10-10 Thread orlandopozo
Hello mailing list, I want to use Oracle function in PHP parser in Win32 OS, but I don't know how to install it, in the official documentation tell this: Installation You have to compile PHP with the option --with-oracle[=DIR], where DIR defaults to your environmment variable ORACLE_HOME. I th

[PHP] Oracle 8i - PEAR - Problem

2003-10-01 Thread orlandopozo
Hello, I have been trouble about to connect Oracle 8i through PEAR db class, I think it is the connection argument, any suggestion could help me, thanks in advanced, here you are the code: Test DB Class - PEAR IdName getMessage()); } //issue the query $sql ="SELECT * FROM test O

[PHP] Oracle 8i problem connection with pear

2003-09-15 Thread ORLANDO POZO
Hello, mailing-list people, I need help about connect the RDBMS Oracle8i through PEAR library, look this code Test DB Class - PEAR NAMEPHONEADDRESS //connect require_once('DB.php'); $db =DB::connect("oci8://system:[EMAIL PROTECTED]/orcl"); // message if (DB::iserror($db)) { di

Re: [PHP] PHP / Oracle support (8/9) under Redhat 9

2003-08-04 Thread Robert Mena
Thanks for the reply. I already use 4.3.1 in my current server. I always compile my version of php since the ones that come with the distro are always too old and usually does not contain support for need features such as mcrpyt or oracle. - rt --- Justin French <[EMAIL PROTECTED]> wrote: > I

Re: [PHP] PHP / Oracle support (8/9) under Redhat 9

2003-08-04 Thread Robert Mena
Hi Juan, But I'd need to compile php with oracle support. Do you have any experience with this setup ? RH9 + PHP with oracle support ? Regards. --- Juan Nin <[EMAIL PROTECTED]> wrote: > From: "Robert Mena" <[EMAIL PROTECTED]> > > > a) apache > > > > It seems that apache + php does not work wel

Re: [PHP] PHP / Oracle support (8/9) under Redhat 9

2003-08-04 Thread Juan Nin
From: "Robert Mena" <[EMAIL PROTECTED]> > But I'd need to compile php with oracle support. > Do you have any experience with this setup ? RH9 + PHP > with oracle support ? nope, have only used it with MySQL... the problem is that the php RPM does not have Oracle support compiled in? if it's that

Re: [PHP] PHP / Oracle support (8/9) under Redhat 9

2003-08-04 Thread Jon Drukman
At 06:33 PM 8/3/2003, Robert Mena wrote: a) apache It seems that apache + php does not work well under heavy load so I should stick with 1.3.X right ? i don't know about that. i'm running an extremely high traffic website with apache + php + linux and it's a total champ. we've got 6 compaq dl3

Re: [PHP] PHP / Oracle support (8/9) under Redhat 9

2003-08-04 Thread Juan Nin
From: "Robert Mena" <[EMAIL PROTECTED]> > a) apache > > It seems that apache + php does not work well under > heavy load so I should stick with 1.3.X right ? Any > ideas where I can find a rpm package for redhat 9 ? Yes, stick with apache-1.3.x Latest 1.3.x version RPM from Red Hat for RH 7.3 is

Re: [PHP] PHP / Oracle support (8/9) under Redhat 9

2003-08-03 Thread Justin French
On Monday, August 4, 2003, at 11:33 AM, Robert Mena wrote: a) apache It seems that apache + php does not work well under heavy load so I should stick with 1.3.X right ? Any ideas where I can find a rpm package for redhat 9 ? I can't help with the Oracle question, but yes, stick with apache 1.3.

[PHP] PHP / Oracle support (8/9) under Redhat 9

2003-08-03 Thread Robert Mena
Hi, I am planning to migrate my current web server from redhat 7.x to 9 and I am currently evaluating what may go wrong or need special attention before I actually replace it. After searching the archives and other lists I still have a couple of questions : a) apache It seems that apache + php

[PHP] Oracle Odbc Connection Problem

2003-07-21 Thread angel
I'm trying to connect to a oracle database using the " Microsoft ODBC for Oracle " driver with the followin script: "; exit; } if ($result = odbc_Exec($conn, $query)) { print "Query returned : " . odbc_num_rows($result) . " rows"; odbc_result_all($result, "border = 1"

[PHP] Oracle CMS

2003-07-17 Thread Chris Cook
Are there any open source CMSs that work with Oracle? Thanks, Chris _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP General Mailing List (http://www.php.net/) To unsubsc

[PHP] Oracle 9.2.0 stored procedure & PHP 4.3.2

2003-06-04 Thread jon
Hi, I have deveolped a stored procedure within oracle 9.2.0. This procedure has an output parameter that is a defined as a REF CURSOR and I would to know if it is posible, using ORA functions in PHP, to run this procedure and retrieve the data contained by this REF CURSOR. I would be very grateful

[PHP] Oracle support under PHP / 8i or 9 and a RedHat 9 / Apache 1.3.X machine

2003-06-03 Thread Robert Mena
Hi, I have a server (currently 7.1) with apache + php compiled with oracle (mcrypt, imap, gettext) support. In order to do so I've installed the 8i linux versions, make a tar.gz of the libs directory and installed in my server. I runs fine accessing a remote (not mantained by me) oracle database

Re: [PHP] PHP & Oracle

2003-03-03 Thread 1LT John W. Holmes
> i have one big Oracle database, 20GB. Is it better to comunicate > directly to Oracle with PHP, or to export data to MySQL. How secure is > PHP & Oracle, can they communicate well? Why would you send it to MySQL? Just get PHP and Oracle talking and go with that. ---John Holmes

Re: [PHP] PHP & Oracle

2003-03-03 Thread Reuben D. Budiardja
On Monday 03 March 2003 09:29 am, Simon wrote: > Hi, > > i have one big Oracle database, 20GB. Is it better to comunicate > directly to Oracle with PHP, or to export data to MySQL. How secure is > PHP & Oracle, can they communicate well? I don't see why you would want

[PHP] PHP & Oracle

2003-03-03 Thread Simon
Hi, i have one big Oracle database, 20GB. Is it better to comunicate directly to Oracle with PHP, or to export data to MySQL. How secure is PHP & Oracle, can they communicate well? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Php Oracle & Word object

2003-02-21 Thread 1LT John W. Holmes
SELECT it out, send Word headers with header() and echo your data. ---John Holmes... - Original Message - From: "M.ALPER KARASAHIN" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 21, 2003 8:53 AM Subject: [PHP] Php Oracle & Word object

[PHP] Php Oracle & Word object

2003-02-21 Thread M.ALPER KARASAHIN
Hi, i want to display a blob column, that contain a word object. My database is Oracle Ver 8.1.7. Php version is 4.2.3 How can i do this? Thanks for your help. Alper.

Re: [PHP] Oracle to MySQL

2003-02-20 Thread Philippe Saladin
> I'm recalling this from memory, and I may not be 100% right, but it > should put you on the right path. You will need to install the Oracle > client libraries on the box with php (you can find these on the Oracle > discs used to install the actual database). Yes > correctly, the Oracle disc

Re: [PHP] Oracle to MySQL

2003-02-19 Thread John Nichel
I'm recalling this from memory, and I may not be 100% right, but it should put you on the right path. You will need to install the Oracle client libraries on the box with php (you can find these on the Oracle discs used to install the actual database). However, if I remember correctly, the Or

[PHP] Oracle to MySQL

2003-02-19 Thread Chris Cook
Hi all, I am working on PHP project with a MySQL backend. However, we would like update the MySQL database periodically with an Oracle database not on our server. What should I do to interface with Oracle? Do I need to install anything on our server (OS X Server running Apache)? Thanks for any

[PHP] Oracle and CLOBs

2003-01-14 Thread Jadiel Flores
Hi, I'm having a big problem with php and Oracle. I'm using Oracle 8.1.6 and PHP 4.2 with the Oracle component in a Solaris server, I can not recompile apache and php to install the oci8 component and I'm having lot of problems with CLOBs, I'm receiving this error: Warning: Ora_Exec failed (ORA

Re: [PHP] PHP/Oracle Command line Segmentation Fault

2003-01-10 Thread Maxim Maletsky
Are you saying that OCILogoff gives you the segfault? It's very strange because OCILogoff is actually an "empty" function - all the contents of that function is commented and is there only for the backwards compatibility reasons. Zend API ends OCI sessions automatically as script's execution ends.

Re: [PHP] PHP/Oracle Command line Segmentation Fault

2003-01-10 Thread Christopher Ditty
Anyone? CDitty >>> "Christopher Ditty" <[EMAIL PROTECTED]> 01/09/03 04:04PM >>> I have successfully installed oracle 8.1.7 w/ php and have it configured to run from the command line. When I run a simple script that connects, and selects records from the database, the last line is a segmentation

[PHP] PHP/Oracle Command line Segmentation Fault

2003-01-09 Thread Christopher Ditty
I have successfully installed oracle 8.1.7 w/ php and have it configured to run from the command line. When I run a simple script that connects, and selects records from the database, the last line is a segmentation fault error. This does not seem to happen when the same script is run through the

Re: [PHP] Oracle 7 support

2002-11-12 Thread Dan Field
> First, let me just say that I'm no Oracle guru. :) But while we're waiting > for them... Thanks, all help appreciated :) > *I think* you need to have Oracle installed even if you wouldn't really > connect to it but instead connect to a different server. Since I installed > Oracle with most of t

Re: [PHP] Oracle 7 support

2002-11-12 Thread @ Edwin
"Maxim Maletsky" <[EMAIL PROTECTED]> wrote: > > Well, I will spread some light - I maintain OCI8 extension :) > > Your machine does not need Oracle Server installed, it needs Oracle > Client installed. These are two completely different things. > > So, try this in your command prompt: > > ec

Re: [PHP] Oracle 7 support

2002-11-12 Thread Chris Hewitt
Dan Field wrote: functionality included. If I recompile PHP, will I need the Oracle headers on the machine also? If so this could be a problem as the Oracle server I wish to use is not on the same machine as the webserver. Seems lots of us have not actually tried doing it without Oracle instal

Re: [PHP] Oracle 7 support

2002-11-12 Thread Maxim Maletsky
Well, I will spread some light - I maintain OCI8 extension :) Your machine does not need Oracle Server installed, it needs Oracle Client installed. These are two completely different things. So, try this in your command prompt: echo $ORACLE_HOME if you get a result, means the client is there a

Re: [PHP] Oracle 7 support

2002-11-12 Thread Maxim Maletsky
Your machine will need the Oracle headers which are included in Oracle Client. So, in two words - your machine needs Oracle client installed. Try doing: echo $ORACLE_HOME in your command prompt -- Maxim Maletsky [EMAIL PROTECTED] Dan Field <[EMAIL PROTECTED]> wrote... : > On Tue, 2002-11-1

Re: [PHP] Oracle 7 support

2002-11-12 Thread @ Edwin
Hello, First, let me just say that I'm no Oracle guru. :) But while we're waiting for them... "Ford, Mike [LSS]" <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: Dan Field [mailto:danf@;ceredigion.gov.uk] > > Sent: 12 November 2002 13:39 ...[snip]... > > That is great news,

RE: [PHP] Oracle 7 support

2002-11-12 Thread Ford, Mike [LSS]
> -Original Message- > From: Dan Field [mailto:danf@;ceredigion.gov.uk] > Sent: 12 November 2002 13:39 > > On Tue, 2002-11-12 at 13:03, Ford, Mike [LSS] wrote: > > > -Original Message- > > > From: Dan Field [mailto:danf@;ceredigion.gov.uk] > > > Sent: 12 November 2002 12:18 > > >

  1   2   3   >