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 conne
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);
OCIBindByName(':enam
the amount of data that can be stored in the CLOB
using this method? My uploads have been truncated to a little less than 32K.
And I 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
Sridhar,
Sorry, it's available at:
http://conf.php.net/pres/index.php?p=slides%2Foci&id=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
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
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
Chuck,
Did you compile PHP with Oracle support? Also, make sure that you compiled
the correct oracle functions. The function you quote is part of the older
oracle functions. There are newer OCI8 functions available.
-Anthony Carlos
> From: Chuck Lidderdale <[EMAIL PROTECTED]>
> D
#146661
I 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 Ko
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 c
o see ORACLE_HOME?
4. There is also some stuff about defining a php variable with the connect
information from tnsnames.ora. I've never actually had to use this method;
the above troubleshooting steps always took care of things for me.
Good luck,
Anthony Carlos
> From: Rao Davide <[EMAIL PR
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: GEORG
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 Attack
quot;;
OCIExecute($stmt, OCI_DEFAULT);
Please let me know 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
Can you show us your OCIConnect statement? It returns a handle to a variable
that you should use as your connection resource...
> From: "Matteo" <[EMAIL PROTECTED]>
> Date: Fri, 24 Aug 2001 10:03:46 +0200
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] [PHP-ORACLE] a lot of errors!!!
>
> I have a s
is is only for MySQL users!
Thanks,
Anthony 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
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
anatory
SELECT 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
-O
Tom:
I suspect that your problem is with the HTML, not the CLOB itself. Have you
tried echoing $lob_data in between tags or using the nl2br function in
PHP? It converts nl's to tags.
Hope it helps,
Anthony
-Original Message-
From: Tom Tsongas [mailto:[EMAIL PROTECTED]]
Sent: Thursday
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 package.
to call up 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
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
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
c
ogon("system","manager");
But now , i 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 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.
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
tec
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 in
26 matches
Mail list logo