Using "OCIBindByName($stmt,$bindname,&${"bindval$ci"},-1);" probably gives
a warning that call-time pass-by-reference has been deprecated.
The OCIBindByName manual entry at
http://www.php.net/manual/en/function.ocibindbyname.php
has a user comment from "alexander dot zimmer at gmx dot at" that thi
Jed wrote:
Hello All,
I'm new to PHP but was able to get some simple sample programs working
accessing a local Oracle database using the php_oci8.dll extension provided
with the php 4.3.4 distribution. I installed the PHP5 beta version but
there is no php_oci8.dll provided, only php_oracle.dl
Christopher Jones wrote:
Jed wrote:
Hello All,
I'm new to PHP but was able to get some simple sample programs working
accessing a local Oracle database using the php_oci8.dll extension
provided
with the php 4.3.4 distribution. I installed the PHP5 beta version but
there is no php_oci
I see the answer has already been given on php-install.
A suggestion which hasn't been made is to use PHP's new oci8
interface in preference to the old one called "oracle" whenever
possible.
To quote from a note on Oracle's PHP forum (see
http://forums.oracle.com/forums/forum.jsp?forum=178 )
"Th
Douglas,
To try and reduce confusion, a "Client" install refers to the option
of that name in the Oracle9i Database Release installer. (The other
options are Database, Mgt & Intg, and Cluster Mgt).
This will install the headers needed to link PHP, if your previous
installer choice didn't load them
nabil wrote:
I have php 4.3.4 on windows as a development environments,
i could not connect to oracle using the native functions,
What error do you get?
> should i connect using ODBC ??
OCI8 has some benefits, depending on what you want to do
now and/or in the future. What are you trying to
William Cheung wrote:
Win 2K server
IIS 4.0
PHP 4.3.4
ADODB 4.10
Oracle 9.2
I got the following error
Warning: ociplogon():_oci_open_server: Error while trying to retrieve
text for error ORA-12538 in C:\PHPRoot\ADODB\drivers\adodb-oci8.inc.php
on line 128
You might be hitting a combination of
Ricardo Lopes wrote:
Is possible to call database stored procedures from php with oracle or any other db?
There is a complete Oracle example in Frank Naudé's Oracle/PHP FAQ:
http://otn.oracle.com/tech/opensource/php_faq.html#PROC
Chris
--
PHP Database Mailing List (http://www.php.net/)
To un
William Cheung wrote:
All the system errors are solved. However, the query seems not returning
any rows. I got undefined index error on any query returns.
Am I hitting the brick wall? Do PHP and ADODB work with Oracle 9.2? Are
there anyone know the answer?
I am using Windows 2K, IIS and Orac
Luis Moran Ochoa wrote:
I've build the typical script for starting apache, it's like this:
$ORACLE_HOME=blablahblah...
more oracle variables
Are the environment variables exported in the script?:
ORACLE_HOME=/my/oracle/home
export ORACLE_HOME
Are all variables needed set?
Are
and it doesn't work neither.
I don't know what more tests to do
I check the permissions too They appear to be right.
I'm completely lost
Christopher Jones wrote:
Luis Moran Ochoa wrote:
I've build the typical script for starting apache, it's like
What's the exact error you get when you try to connect to oracle and
what command are you using to connect?
Does a phpinfo() script show the Oracle env vars correctly under the
"Environment" section?
Chris
Luis Moran Ochoa wrote:
These are the exact details...
/usr/oracle permissions 750 owner o
Delfins wrote:
i have successfully installed Oracle 9.2 on Slackware 9.0
database works fine & also any other applications runs ok.
but when i compiled PHP5 with OCI8 (path i was specified as ORACLE_HOME)
but running some scrip, i have this error :
Warning: ocilogon(): _oci_open_server: Error wh
Elke Stahl wrote:
i successfully stored blobs in an oracle table via php. but it seems to be
impossible getting them back to filesystem!
It is a binary (no picture or executable) which arives via mail and is
written into a unix-filesystem.
iÂve stored this binary as blob datatype together with o
Josef Suchanek wrote:
> my platform is W2K or WXP. For the first I tried Apache 1.3.22
> included in Oracle 9i installation with bad result. Then I tested
> Apache 1.3.29 with the same bad result. Then I tried IIS without
> problem and last test was with Apache 2.0.48. It worked fine too.
What abou
Comments below.
Jim Morrison wrote:
Hello all,
Hope this isn't an FAQ - have trawled google, otn.oracle, php.net etc -
not sure I can find the answer..
I've been using php&mySql for a while now and getting on great - however
I'm now tasked with getting my php to talk to a _remote_ ( right next t
Justin Patrin wrote:
Adam Williams wrote:
Hi, I have oracle and PHP working together on a remote server called
zed that runs redhat linux. I have another computer called
accessserver that runs win2k pro with PHP that I am trying to connect
to oracle on zed. Both computers have the oracle cl
Joseph Burch wrote:
Foolks -
In building the Apache PHP-Oracle interface we have discovered a
discrepancy between the functions listed in the PHP on-line
documentation and the function list obtained by "nm" for libphp4.so.
Our UNIX Solaris build comprises Apache_1.3.29, PHP-4.3.4, and the full
se($conn, $query);
OCIExecute($stid);
OCIFetchInto($stid, $row, OCI_ASSOC);
echo ""; var_dump($row); echo "";
OCILogoff($conn);
?>
--
Christopher Jones, Oracle Corporation, Australia.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Philippe wrote:
Hi,
I am experiencing the message in the title of this message when starting
or restarting Apache. I have the following configuration:
- Windows XP
- Apache 2.0.49
- PHP 4.3.6
- Oracle Client 8i
If anyone has any information as to why this is happening and how I can
solve it, I
database management tool called Aqua Data Studio which
uses native connections.
Christopher Jones wrote:
Philippe wrote:
Hi,
I am experiencing the message in the title of this message when
starting or restarting Apache. I have the following configuration:
- Windows XP
- Apache 2.0.49
- PHP 4.3.6
Philippe wrote:
Well, the exact message is: "Unable to load dynamic library
php_oci8.dll: The specified procedure could not be found"
If I remove the library the message becomes "The specified module could
not be found." It seems to be able to find the library (all the paths
are correct) but it
Joshua,
I see this is the question asked on
http://forums.oracle.com/forums/thread.jsp?forum=178&thread=248354&tstart=0&trange=15
I'll followup on the OTN forum, not to this PHP-DB mail list.
Chris
Joshua Skagemo wrote:
Hi,
I am trying to call a procedure in Oracle 9i but I just can't get it to
w
Justin Patrin wrote:
Charles Morris wrote:
putenv("ORACLE_SID=PROJ");
putenv("ORACLE_HOME=/home/oracle9");
I have tried putenv myself and it doesn't seem to work for Oracle
connections. Putting those in your shell environment, then restarting
apache. Check to see if the env vars are set
Rafi Sheikh wrote:
Hi list. I am a newbie and would like to ask if anyone could give me the
proper syntax for connecting with oracle DB. For example with MySQL it is:
mysql_connect..., mysql_query...
For MS SQL Server:
mssql_connect..., mssql_query...
There are various examples in the PHP documen
Peter Beckman wrote:
> How do I get connected from a remote PHP+Apache box to Oracle9i on linux?
The current Oracle Instant Client bundle is fine for using PHP on
Windows, but does not have headers for compiling PHP with Oracle
support on other platforms. An Instant Client SDK with headers is
comi
Beni,
You have two related problems: (i) the error ORA-12154 and (ii) Oracle
couldn't find its data file containing the error text to display with
ORA-12154.
Make sure the standard Oracle environment variables are set in the
environment that starts the web server. See
http://otn.oracle.com/tech/
Adam Williams wrote:
yeah I got it to work, i had to do putenv() with my oracle home dir and
then my scripts started working. thanks
It would be better to set the variables before starting the web server.
See http://otn.oracle.com/tech/opensource/php/php_troubleshooting_faq.html#envvars
Chris
--
It might be a feature of PHP's connection caching. Why don't
you log a bug in the PHP bug DB so the problem can be tracked?
Do you really need to keep reconnecting?
See
http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq.html#conmgt
Chris
yannick wrote:
I have some troub
Jon Foreman wrote:
Does anyone have any suggestions for the following problem:
I'm running Apache/1.3.31 and PHP Version 4.3.8 connecting to an Oracle
database. Periodically, PHP is unable to connect to the database. When this
problem occurs, I am able to connect to the database from the webserver
thod, I did an "posix_kill(getmypid(),15);"
I know, I won't win the programmers Nobel-Prize for that crap, but it
works so far; dropped connections are reconnected.
Dieter
Christopher Jones sagte:
D.Wilkening wrote:
Hi everyone,
i've a problem using php with oracle 10g.
(php 5.0.
Chris wrote:
I m trying to make a program with PHP and Oracle
I want to use an "Select for upate"
But when i send the command, it doesn t lock my "table"
If someone can help me
Is row-level locking happening?
When are you checking the locks?
A couple of references (free reg required):
http:
Chris wrote:
Is row-level locking happening?
I think that the lock doesn t work
When are you checking the locks?
I am checking the lock with an SQLPLUS session
If i lock my table with SQLPLUS, PHP can make an select for update
But if i try to lock with PHP i can make an other select for update wit
[EMAIL PROTECTED] wrote:
I'm trying to write text to a BLOB. I got a valid return code but it did not write the BLOB.
> I was able to use similar code writing to a CLOB. Any examples I've seen for BLOBs
are reading
> from Binary files. Here's how I did the CLOB, but it would not work for BLO
Chris Back wrote:
Hi,
I am hoping that someone can help diagnose this issue.
I am able to successfully connect to and query a remote Oracle 9.2
database from apache2/php5. However, when I have multiple clients
hitting my php scripts, all of which require a connection to the
database, problems begi
During my presentation at the PHP Conference in Frankfurt I put
out a call for participation in creating a roadmap for Oracle
connectivity in PHP.
When I get back to work (I'm on a short vacation in Europe with
intermittent email access) I'll be following up on this. While I'm
away, feel free t
Adriano Rocha wrote:
> I'm running Linux RedHat7.3 with PHP 4.3.3.
root # > ./configure --with-oci8 (no errors)
root # > make (no errors)
root # > make install (no errors)
... it does not create the oci8.so file. Obviously, php pages on OCILogon
and related functions crashes with undefined func
Roger,
You can see the real Oracle error number if you replace the getMessage()
calls with getDebugInfo() or getUserInfo().
Making this change gave this output:
Connecting . . .
CREATE TRIGGER test_trigger before insert on test for each row begin
select test_seq.nextval into :new.id from
Roger Spears wrote:
I'm using PHP/PEAR to execute my queries on an oracle table. I'm trying
to store very long pieces of text into a CLOB field. Currently I'm
getting a string too long error.
I've tried:
OCIBindByName($sql,":fieldName",&$myVariable, -1);
But I'm not sure I'm using it correct
Sergio Hernandez wrote:
Hi, we are working in php with oracle and we have a stupid problem.
We are trying to obtain the return value of a variable. But after
execute the function it give to us an empty value, its return 0 columns
and 1 row. We have prove this function in oracle and it give a go
Roger Spears wrote:
I've been working on this all day. I'm trying to insert some text
($essay) into a CLOB field (essay) in my table (clob_test).
Can someone please tell me why the following PHP code returns ORA-01036:
illegal variable name/number? Better yet, please tell me how to fix it??
$
Johan Kruger-Haglert wrote:
I've been trying to get Linux+apache+php+oracle working here with no
success, so I've to ask for some help.
Versions:
RedHat 9.0
PHP 4.3.4RC1
Oracle Enterprise Server 9.2.x
Oracle client 8.1.7
The machine has to run RedHat, and newest version would be good.
Oracle9.x doe
kss wrote:
> I'm using php/oracle9.2 .
> i cant' login into oracle db using ocilogon() as "SYS" user.
> above 9i , in order to login as "SYS" user
> 5th parameter of OCISessionBegin must be "OCI_SYSDBA"(not OCI_DEFAULT);
> my suggestion !!
>
> PHP ocilogon specification
> resource ocilogon ( str
John Mullins wrote:
Has anyone come across this behavior? We've built php 4.3.2 with
Oracle support (both --with-oracle and --with-oci8), but when I
try to start up Apache with the ORACLE_HOME env variable set to
the Oracle home location, it core dumps with this error:
KGP-00600: internal erro
Ludányi Levente wrote:
Hello
I'm trying to use the OCINewCollection function, but if I don't specify the 'schema'
parameter for this function, then I get the 'ocinewcollection(): OCI8 Recursive call!'
error message, and the page never appears (I must restart IIS). If I give a typename,
that do
MaNu wrote:
Function :
FUNCTION PREZZO_TOT (
pUtente in v_utenti.utente%type,
pTrasp in char
) return NUMBER;
Php
$query = "SELECT poe.carrello.prezzo_tot('AATCXNK2EN3RDKB','1') PIPPO FROM dual";
$parsed = ociparse($conn,$query);
ociexecute($pars
I don't have this combo to test unfortunately.
It may be an include path problem. Check the Makefile has a
valid -I path for the Oracle headers.
An unrelated issue to be aware of is http://bugs.php.net/bug.php?id=25980
Chris
Daniel Sand wrote:
Hello,
The system is Solaris sun4u sparc SUNW,Ult
Doug McMaster wrote:
Regardless of how I set the NLS_DATE_FORMAT parameter, when I do a select
statement DATE fields are returned in the Oracle default DD-MON-RR format.
I can successfully set NLS_DATE_FORMAT using either an environment variable
and restarting apache or by using ALTER SESSION SE
Juffermans, Jos wrote:
Hi,
Some of our scripts that generate customer-facing pages, need a connection
to a database. The problems is that the database is in Norway and -
allthough we have a VPN setup - the connection isn't always available.
In case the connection cannot be made, we can redirect
Here are some things you could try.
Remove all the "@" suppressions and make sure error_reporting = E_ALL
and display_errors = On are set in your php.ini.
Echo the SQL statement inside SQLInsertLob() to make sure it is
constructed OK.
Echo the filename to check it includes the appropriate path. If
e hardcoded version (see the
uncommented $db above).
sqlnet.ora contains a value name_domain that apparently is appended to the
alias in tnsnames.ora but accounting for this still doesn't let me connect
to oracle . It's as if tnsnames.ora cannot be found. I've changed the
permissions
Leo D. Geoffrion wrote:
I recently upgraded to PHP5 and now have a curious Oracle problem.
The PHP scripts query the database fine. Then overnight, the database
shuts down for backup and restarts. The next day, PHP can no longer
connect to the database until I restart Apache. Then, it's happy
description
of the database alias within tnsnames.ora
However this is not good, so if you have any other idea please let me
know. I'm flumuxed.
thanks,
neil
>From: Christopher Jones <[EMAIL PROTECTED]>
>To: neil smith <[EMAIL PROTECTED]>
>CC: php-db@lists.php.net, [EMAIL P
neil smith wrote:
Hi Martin,
It's a legacy application that is huge and sprawling and teh programmers
who developed it left along time ago , apparently. It would probably be
easier to write a whole new application then convert it to php 4 or 5
and thankfully thats not what I've been asked to do.
The --with-oracle option is a long deprecated interface to Oracle
and no-one has updated the configure script to work with Oracle 10g.
Can you use the new --with-oci8 option? Otherwise you'll need to
update ext/oracle/config.m4. The code in ext/oci8/config.m4 may help.
With either configure optio
Use the phpinfo() function to check that the same php is being used in
Apache and on the command line.
Make sure LD_LIBRARY_PATH contains $ORACLE_HOME/lib
Relink with --with-oci8
Another suggestion is upgrade PHP to 4.4 and manually get the new
refactored oci8 drivers. After you upgrade to som
What line of code is 1546? How are you binding/executing/fetching?
Are you using OCI_B_CLOB?
If you post a complete (small) testcase we may can look at it.
Please include DDL to create any table.
Most importantly, use the refactored OCI8 driver:
http://pecl.php.net/package/oci8
-- cj
Script
Rasim ÞEN wrote:
Hi friends ,
my code like this
$sql="SELECT mid,substr(ROWID,0,100) as nROWID,MEMBER_ID, NAME, SURNAME,
E_MAIL, SUBJECT, MAIL_BODY, to_char(DATE_CREATED,'DD.MM. HH24:MI:SS') as
DATE_CREATED, RETRY, PRIORITY, E_MAIL_FROM, RECEIVER_MEMBER_ID,
RECEIVER_NAME, RECEIVER_SURNAME
RIOTTEAU Gwénaël wrote:
Hi,
i try to connect my PHP application with Oracle.
But i have some random errors (with the function OCIStmtExecute) :
ORA-12152: TNS:unable to send break message
ORA-03114: not connected to ORACLE
sometimes it works well, sometimes not (for the same query)
Rando
27;ll have to
compile php from source with the extra option:
--with-oci8
I suspect you'll have to compile php from source, you won't be able to
use a package to do this, but I could be wrong.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
Christopher Jones, O
bleshooting_faq.html#notinst
If you're using a DB (version 8,9 or 10) on another machine
check the steps on using PHP with Oracle Instant Client, this
should be easier to work with the the full Oracle client.
Chris
--
Christopher Jones, Oracle Corporation, Australia.
Email: [EMAIL PROTECTED
t do something like:
$s = oci_parse($c, 'insert into ptab (pdata) values (:bv)');
oci_bind_by_name($s, ':bv', $v, 20, SQLT_CHR);
foreach ($a as $v) {
$r = oci_execute($s, OCI_DEFAULT);
}
oci_commit($c);
Or explore calling a PL/SQL block and do a bulk FORALL i
ers.
Or build up the statement using PHP string concatenation.
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
As an
example of how crappy it is, it omits the "put" method from class Db4
but that method does in fact exist within the library.)
Thank you for any help you can offer. I have searched the web and the
archives of this list but I couldn't find much.
--
Christopher Jones, Ora
ne is at:
http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
r is there but not the 9i client for linux ( I just wonder why).
Thanks.
On 12/27/06, Christopher Jones <[EMAIL PROTECTED]> wrote:
PHP's oci8 extension on Windows is now compiled with an Oracle 10g client
and depends on new functionality in it. The 10g Oracle Instant Client is
free
port to work.
Anyone able to help?
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
p://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
oracle.com/technology/forums/xml.html
The people who monitor those lists are specialists.
Chris
Ritesh Nadhani wrote:
I just checked: http://www.oracle.com/technology/tech/xml/xmldb/index.html
Is the solution free or we have to pay license cost? I dont see any
information about that.
Christopher J
.
Webserver is IIS on my local box. PHP is running on my local box.
I've got TNS_ADMIN set as an env variable
Any help gratefully received :-)
Cheers
Steve
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Christopher Jones
you need to do is add a couple of configuration lines and restart
the network listener to get encrypted traffic. Check your license too:
the Advanced Security Option (ASO) is probably a separately licensble
product.
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506
is gradual work being done on PDO and I would
encourage people to pound on it. I'm calling 2008 "the year of PDO".
Sure hope I don't have to change that to "2009"!
What are the configure problems?
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel:
,
you could create a mapping function in PL/SQL. There is a related
example under the heading "Using PL/SQL Types in PHP" on page 141 of
the current (1.4) version of
http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf
Also see the use of SDO_UTIL.GETVE
a"
bool(true)
bool(true)
einepideinepid
(The value is repeated because the array contains numerically and
associatively indexed values.)
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyu
searching for.
select * FROM projekte_generisch where pid='u0test'
PID ANFANG ENDELAENGE
u0test utest 8
Hope this helps diagnosting the error.
Do other queries with binds work? Is PHP using the correct
NLS language configuration?
Chris
--
Christopher Jones, Oracle
Email: [EM
older oci_bind_by_name() call. You can pass SQLT_AFC (i.e
the CHAR type) to the former but not the latter.
If anyone volunteers to write some test cases I can merge a patch to
OCI8 to allow:
oci_bind_by_name($s, ':bv', $bv, -1, SQLT_AFC);
Chris
--
Christopher Jones, Oracle
Email: [
Daniel Brown wrote:
> On Mon, Jul 21, 2008 at 12:22 PM, Mad Unix <[EMAIL PROTECTED]> wrote:
>> How could I build the OCI8 extension module for php5 under CentOS5?
>> I have installe PHP/APACHE/MYSQL through yum install ...
>
> OCI8 is a PECL extension.
>
> 'pecl install oci8'
>
> If
Walter Galvão wrote:
Hi,
Im using the oracle instant client basic in my php app, with apache server.
When a query returns few rows, there is no problem.
Otherwise, the oci_execute method doesn return any records neither errors!
How can i solve this problem??
My implementation:
function execu
Walter Galvão wrote:
Are you exceeding the PHP script time out, or exceeding the memory
limit?
I dont know. Doesnt appear any message. The script prints the
last message before the oci_execute call.
I'd start by looking at the max_execution_time and memory_limit settings in
php.ini.
Chri
Chris wrote:
> Hi all,
>
> Using php 5.2.6 + oci driver 1.3.4 from pecl
>
> Has anyone had any issues with the oci8 driver performance?
>
> I'm doing some profiling using xdebug and all of the time seems to be
> spent in oci_execute and oci_fetch_array. This shows up when I use
> jmeter to hit t
mignon hunter wrote:
> I'm am trying to find some definitive best practises on database connections
with php on both mysql and oracle.
>
> I'm starting to redesign a corporate website and am trying to find out more
about security and the best practises for database queries and user input form
mignon hunter wrote:
> Hi Christopher
>
> One other question. Our current site is written in jsp with
> Oracle. I'd like to use PHP. Do you have any thoughts on this?
My recommendation is to utilize the existing skills you have; this
echoes Fergus's comment. However, PHP is very popular and if
Hi Fred,
[EMAIL PROTECTED] is a development mail list. The best place to
post to is [EMAIL PROTECTED] I'm ccing that list: please remove
pecl-dev from any followup mail.
Fred Silsbee wrote:
> I have Fedora 9 2.6.27.5-37.fc9.i686 and Oracle 11g1
> [EMAIL PROTECTED] oci8-1.3.4$ phpize also t
Fred Silsbee wrote:
> provide some detailed instructions for oc8/linux install that leave no gaps
>
> instructions that work for newbies
For newbies we recommend installing Zend Core for Oracle.
Are you the same person as person who has been posting to the OTN
forum, e.g. this post
http://forum
I'm CCing the php-db list.
Fred Silsbee wrote:
> install Zend?...never! I have Fedora 9 and 11g1 Enterprise
>
> I have Apache working and Oracle 11g1 installed and working!
>
> Zend installs both of these and could screw up my working system.
Zend Core for Oracle will use your existing Apache.
I'm CCing php-db again.
Fred Silsbee wrote:
> This worked:
>> sqlplus hr/[EMAIL PROTECTED]
> so I tried: (didn't work)
> if ($conn=oci_connect('hr', 'hr', '//localhost/LMKIIIGD'))
Excuse me repeating the example PHP code I gave earlier for this
SQL*Plus case:
Or if you connect like:
Fred Silsbee wrote:
> there is a file /etc/httpd/conf/httpd.conf
>
> I tried putting the ORACLE_HOME in this file but it failed
What failed and how?
How was it set?
[phpinfo output of]
>>> Compile-time ORACLE_HOME no value
The lack of a value here is an artifact aka buglet of installing fr
Fred Silsbee wrote:
> GREAT!!but how!
How what?
> http://us.php.net/manual/en/oci8.setup.php
What about it?
>> [phpinfo output of]
> Compile-time ORACLE_HOME no value
>> The lack of a value here is an artifact aka buglet of
>> installing from
>> the PECL package. I'll a
Fred Silsbee wrote:
http://bugs.php.net/bug.php?id=43186
Why do you think it's a clue? Are you getting a crash?
Does your PHP command line work?
So far we have almost zero information about your configuration in particular
we don't have phpinfo() output (despite suggestions you check it).
Fred Silsbee wrote:
> I have the following in /etc/httpd/conf/httpd.conf
>
> SetEnv ORACLE_HOSTNAME localhost.localdomain
> SetEnv TNS_ADMIN /u01/app/oracle/product/11.1.0/db_1/network/admin
> SetEnv ORACLE_BASE /u01/app/oracle
> SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1
> SetEnv OR
Chris wrote:
Themis Vassiliadis wrote:
You are right but sqlrelay doesn't work on Windows plataform and the
only possible solution from oracle to connect PHP using pooling is
DRCP, just on 11G, but as far as I know it hasn't been implemented
integrated with PHP.
All you have to do is chang
Themis Vassiliadis wrote:
>
> On Tue, Dec 2, 2008 at 4:18 PM, Christopher Jones
> <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:
> Oracle 11g DRCP support is available in PHP. See this whitepaper:
> http://www.oracle.com/technology/tech/php/pdf
Themis Vassiliadis wrote:
> DRCP is really a big improvement. But for me it has a great holdback:
> the pool controlled in the server side isn't defined for a specific
> schema, so if we have an application server serving different
> connections demanding different credentials certainly the perfo
Tonado wrote:
> Hi all,
>
> I used the following in my code
>
> oci_connect('$user','$pass',$connectionString,'UTF8');
>
>
> and got the following warning:
>
> Warning: oci_connect() [function.oci-connect]: Invalid character set
> name: UTF8
> I tried many times and found it could only
>> $band_id = $_SESSION['session_var'];
>> $query="SELECT * FROM pic_upload WHERE band_id=$band_id";
It's always better not to concatenate user input into queries, otherwise
you are vulnerable to SQL Injection attacks:
http://www.sans.org/top25errors/#cat1
Use bind variables with the appropri
Jérôme Loyet wrote:
> Hello,
>
> I used to use oci8 version 1.2.3 and I wanted to update to last
> version (1.3.4). Everything works fine except the fact that
> "sqlnet.ora" does not seems to be read.
>
> I use the following string to describe my database in oci_connect: "MEN1PRD".
>
> In sqlnet.
Jérôme Loyet wrote:
> My init script where the ENV are set:
>
> export ORACLE_HOME=/usr/local/oracle/VERSIONS/Linux/CL.9.2.0
>
PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/network/admin:$ORACLE_HOME/lib:/usr/local/bin
(The admin and lib directories aren't needed in the PATH because they
don't conta
Chris wrote:
Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed.
There is something wrong with your system - please check that
LD_LIBRARY_PATH includes the directory with Oracle Instant Client
libraries in/Library/WebServer/Documents/oracle.php on line 25
Oracle
Grant Croker wrote:
> DYLD_LIBRARY_PATH=/opt/oracle/instanceclient
> LD_LIBRARY_PATH=/opt/oracle/instanceclient
> ORACLE_BASE=/opt/oracle/instanceclient
> ORACLE_HOME=/opt/oracle/instanceclient
> export DYLD_LIBRARY_PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME
>
> (note: As Chris Jones mentioned
Thomas Robitaille wrote:
I've managed to fix the issue by switching to a 32-bit installation of
MySQL and Apache. The problem appeared to be due to the 64-bit versions
somehow.
If you think there's a bug (and you tested the latest version of PHP),
please report the problem at http://bugs.php
1 - 100 of 122 matches
Mail list logo