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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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??
$
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'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
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
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
101 - 122 of 122 matches
Mail list logo