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
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);
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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
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.
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
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
22 matches
Mail list logo