[PHP-DB] Oracle/PHP question...

2002-12-17 Thread Anthony Carlos
Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup

Re: [PHP-DB] Oracle problem

2002-10-16 Thread Anthony Carlos
Perhaps it would be easier to use bind variables instead. For example, $empno = 1234; $ename = O'Reilly; $conn = OCILogon('scott', 'tiger'); $sql = 'INSERT INTO emp (empno, ename) VALUES (:empno, :ename)'; $stmt = OCIParse($conn, $sql); OCIBindByName(':empno', $empno, -1);

[PHP-DB] Updating a CLOB-- OCI_INVALID_HANDLE

2002-07-15 Thread Anthony Carlos
thought using a CLOB was supposed to give me access to 4GB... Thanks for any insight! Anthony Carlos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Oracle client on linux

2002-01-25 Thread Anthony Carlos
There's a bunch of requirements that have to be met in order for the software installer to work. In case you're installing onto a remote machine, do you have XWindows running on your Linux machine? Does your terminal program support XWindows? From: aiQa [EMAIL PROTECTED] Date: Fri, 25 Jan 2002

Re: [PHP-DB] Oracle Database procedures

2002-01-25 Thread Anthony Carlos
Sridhar, Take a look at this documentation from Thies Arntzen. It's required reading for anyone using Oracle and PHP! I hope it gets you started. If not, ask for more help! Good luck, Anthony Carlos PS: It shows how to bind PHP variables to Oracle variables... From: Sridhar Moparthy [EMAIL

Re: [PHP-DB] Oracle Database procedures

2002-01-25 Thread Anthony Carlos
Sridhar, Sorry, it's available at: http://conf.php.net/pres/index.php?p=slides%2Fociid=oci2 Good luck! --Anthony From: Anthony Carlos [EMAIL PROTECTED] Date: Fri, 25 Jan 2002 09:50:26 -0500 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Oracle Database procedures Sridhar, Take a look

Re: [PHP-DB] Re: Unable to Open ORACLE

2001-12-03 Thread Anthony Carlos
suggest using this with stored procedures and bind variables. php.net has more info on using stored procedures bind variables. Good luck, Anthony Carlos From: John Kolvereid [EMAIL PROTECTED] Date: Mon, 03 Dec 2001 22:17:44 -0800 To: [EMAIL PROTECTED], John Kolvereid [EMAIL PROTECTED

Re: [PHP-DB] ORA-24365

2001-11-19 Thread Anthony Carlos
This might help... 24365, 0, error in character conversion // *Cause: This usually occurs during conversion of a multibyte // character data when the source data is abnormally terminated // in the middle of a multibyte character. // *Action: Make sure that all multibyte

Re: [PHP-DB] php and Oracle database

2001-09-27 Thread Anthony Carlos
Georgina: Based on your 2 enclosures, it appears that you have an html file called search1.html. When the user hits the submit button, it calls search1.php4. My question, therefore, is do you have output from search1.php4? Do you see any error messages? Thanks, Anthony Carlos From: GEORGINA

Re: [PHP-DB] USA Attacks

2001-09-11 Thread Anthony Carlos
Hello, Steve. Thank you for your sentiments. As an American who drives past the Pentagon everyday to work, it means a lot. Anthony Carlos From: Steve Farmer [EMAIL PROTECTED] Date: Wed, 12 Sep 2001 12:28:28 +1000 To: [EMAIL PROTECTED] Subject: [PHP-DB] USA Attacks Hi, My heart goes

Re: [PHP-DB] creating an Oracle variable...

2001-09-10 Thread Anthony Carlos
if this makes sense, Anthony Carlos From: [EMAIL PROTECTED] Date: Mon, 10 Sep 2001 11:10:04 -0800 To: [EMAIL PROTECTED] Subject: [PHP-DB] creating an Oracle variable... Hi, I creat the variable test using the sql plus: var test varchar2(10); I´ve been trying to do it wiht PHP

RE: [PHP-DB] Photo Album Schema

2001-08-21 Thread Anthony Carlos
I vote for one directory to simplify the programming side of things. What do you guys recommend for the filename convention? Would you let users determine it or would you force them into something like a primary key? Anthony Carlos -Original Message- From: Rick Emery [mailto:[EMAIL

RE: [PHP-DB] oracle (oci8) intro

2001-08-21 Thread Anthony Carlos
Carlos -Original Message- From: Manuel Lemos [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 3:03 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] oracle (oci8) intro Hello, Anthony Carlos wrote: Here's what I'm using to do paged queries in Oracle: $min = minimum of range

RE: [PHP-DB] oracle (oci8) intro

2001-08-20 Thread Anthony Carlos
linenum, $field_list FROM (SELECT rownum AS linenum, $field_list FROM (SELECT $field_list FROM $table WHERE $where_clause ORDER BY $order_by)) WHERE linenum BETWEEN $min AND $max; I hope it helps, Anthony Carlos -Original Message

RE: [PHP-DB] Oracle CLOBs and carriage returns

2001-08-09 Thread Anthony Carlos
Tom: I suspect that your problem is with the HTML, not the CLOB itself. Have you tried echoing $lob_data in between PRE tags or using the nl2br function in PHP? It converts nl's to BR tags. Hope it helps, Anthony -Original Message- From: Tom Tsongas [mailto:[EMAIL PROTECTED]] Sent:

Re: [PHP-DB] long or LOBs in oracle ???

2001-08-01 Thread Anthony Carlos
Andy: Go with the CLOB. As you stated, you can have more than one CLOB defined in a table. Also, you can pull out data randomly instead of sequentially. Plus, the data can reside inline (for less than 4KB) or out of line for bigger values. The key to making it work is using the DBMS_LOB

RE: [PHP-DB] Oracle Client Libraries?

2001-07-11 Thread Anthony Carlos
Oracle for current pricing. Anthony Carlos -Original Message- From: Tom Tsongas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 12:56 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Oracle Client Libraries? Hi all. Where can I get the Oracle client libraries for PHP4? I am running

Re: [PHP-DB] problems connecting to remote oracle database

2001-07-02 Thread Anthony Carlos
Phil, Perhaps I'm being nit-picky, but shouldn't it be OCILogon($user, $PASSWORD, $connect_string); ? Anthony From: [EMAIL PROTECTED] Date: Sat, 30 Jun 2001 09:39:11 -0700 To: [EMAIL PROTECTED] Subject: [PHP-DB] problems connecting to remote oracle database Hi folks, I'm having

RE: [PHP-DB] Oracle Client to connect to remote DB

2001-06-30 Thread Anthony Carlos
Yes, it can be installed via command line. There is mention of it in the installation guide. I've never been able to make it work, however, and I don't believe that Oracle is supporting it as much as its GUI Universal Installer. On the other hand, I have used the Universal Installer over an ssh

RE: [PHP-DB] error ORA-12699

2001-06-29 Thread Anthony Carlos
cannot connect local oracle server!! It is always said the ORA-12699 error! I donot know what is wrong. sang Anthony Carlos [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Sang, Since you're trying to connect from another computer to the Oracle serv

Re: [PHP-DB] error ORA-12699

2001-06-27 Thread Anthony Carlos
Sang, Since you're trying to connect from another computer to the Oracle server, you probably need to specify a connect string in the OCILogon command. OCILogon('system', 'manager', $connect_string); What's the value for $connect_string? It depends on how you've set-up your Oracle networking.

RE: [PHP-DB] Oracle and PHP

2001-06-26 Thread Anthony Carlos
TathitSA, You'll need to have the Oracle networking software (Net8) installed on your Web server. Then, compile PHP with the Oracle directive turned on. These are just general concepts, but if this is incomprehensible, then please ask more questions before proceeding. For more details, see the

RE: [PHP-DB] Oracle Client to connect to remote DB

2001-06-26 Thread Anthony Carlos
Jeff, When you run the graphical Oracle Installer program (require X-Windows), you can choose a custom installation and specify what you want to install. I don't know if you can get just the client for Linux, but the server software includes the client software. You can demo the software from