Hi there,
I hope that one or another Oracle specialist is on our list, so here's
something special for you:
I recently upgraded from Zend Core for Oracle 2.0 to 2.5 (I still use the same
php.ini I used with 2.0), and now my database language setup is messed up! All
german umlauts are gone and
fic). the BFILE
allows you
to keep your images in the file-system so they don't clutter
your
table-space but you can still access them as if they were a part
of your
database!
-Original Message-
From: Alf Stockton [mailto:[EMAIL PROTECTED]
Sent: 23 May 2007 13:33
To: php w
Can someone suggest a method whereby one retrieves an Oracle BLOB &
subsequently display same on a HTML page?
If possible an example would be great.
--
Regards,
Alf Stocktonwww.stockton.co.za
Don't plan any hasty moves. You'll be evicted soon anyway.
My email disclaimer is availabl
With the attached php program I keep getting:-
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-06550:
line 1, column 7: PLS-00306: wrong number or types of arguments in call
to 'SPMEMBERDETAILS' ORA-06550: line 1, column 7: PL/SQL: Statement
ignored in C:\Program Files\Apache
Grou
My Oracle database sits on a Windows XP machine on the d: hdd.
My tnsnames.ora therefore sits in
d:\oracle\ora92\network\admin\tnsnames.ora.
Is there any problem with the above configuration?
--
Regards,
Alf Stocktonwww.stockton.co.za
Linux 2.6.12-9-386
You work very hard. Don't
I am very new to Oracle and I cannot get my php script to connect to an
Oracle database from the following statement:-
$conn=OCILogon("big", "big", "s6s");
and the variables are as far as I am concerned, correct.
Where can I look in Oracle to see some detail of why I am not succeeding.
--
Hi NG!
Consider the following piece of (simplified) code:
$sql = "SELECT * FROM table";
$sth = ociparse ($conn, $sql);
ociexecute ($sth);
$sql = "SELECT * FROM table2";
$sth = ociparse ($conn, $sql);
ociexecute ($sth);
I have just been reading an article on php|arch that states that each open
st
Does anybody here have experience of getting Oracle 10g set-up with PHP4?
I have uncommented the DLL, registered the ORACLE_HOME & ORACLE_SID
environment vars and yet when I try to run oci_connect I get an error from
PHP saying that I am calling an undefined function.
I really need help with this
All,
I have the 1.3.12 version of Apache installed (via an Oracle install -- no
source) on a Win 2000 system and I have downloaded the manual verion of PHP
(not the Windows Installer). I configured PHP via the SAPI method and
everything works great, including access to SQLServer and Access (ODBC)
Hi,
I have tried both, it seems Oracle (i.e Ora_?) is much faster but OCI8 is
more powerful. So, how can I tune OCI8 in order to have faster response.
Also, I can't use Ora_bind() inside a function. Ora_exec will return an
error of "Cannot find variable" when executed. Is there any way to sol
Hi
when I'm trying to connect to my oracle db with
";
$db = "authors";
$c1 = ocilogon("pawel","pawel",$db);
function select_data($conn)
{ $stmt = ociparse($conn,"select * from pawel.authors");
ociexecute($stmt,OCI_DEFAULT);
echo $conn."selecting\n\n";
while (ocifetch($stmt)){
echo o
Help, i'm trying to connect to a remote oracle database from
win98/apache/php4 and win2k/iis/php4 but it always gives me tns error. Other
apps however, works fine with the tns configuration. the php oracle module
was loaded successfully on both platforms.
I've tried all sorts of possibilities. pat
Help, i'm trying to connect to a remote oracle database from
win98/apache/php4 and win2k/iis/php4 but it always gives me tns error. Other
apps however, works fine with the tns configuration. the php oracle module
was loaded successfully on both platforms.
I've tried all sorts of possibilities. pat
I have a simple script in php :
putenv("ORACLE_HOME=D:\\ORANT");
putenv("TNS_ADMIN=D:\\ORANT\\NETWORK\\ADMIN");
putenv("ORACLE_SID=x");
echo "Oracle : ". getenv("ORACLE_HOME")." \n";
echo "TNS_ADMIN : ". getenv("TNS_ADMIN")." \n";
echo "ORACLE_SID : ". getenv("ORACLE_SID")." \n";
$conn
I provided the 2 forms, but it don't work.
- Original Message -
From: "Randall Barber" <[EMAIL PROTECTED]>
To: "Marisol Díaz E." <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 4:57 PM
Subject: Re: [PHP-WIN] oracle
> Escape the \ with \\
Hi,
I'm working with php4 and oracle in windows2000,
I have problems with this variables.
$lugar="D:\Oracle";
$bdd="orant";
PutEnv("ORACLE_SID=$bdd");
PutEnv("ORACLE_HOME=$lugar");
It don't work, I don't know what is the value of $lugar.
Thanks.
Marisol
while (ora_fetch_into($curs, &$row1)){
explode($row1);
echo "$NAME now = ".$rowl[1];
(I think the function is explode, if not I'm sure it begins with an e, if
that helps... ;-)
"Tom Mathews" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> In MySQL, you can
In MySQL, you can run something like this: -
while ($row1=mysql_fetch_array($result_set)){
$name=$row1[Column1];
$desc=$row1[Column3];
echo"$name$desc";
Does anyone know a way of doing the same with oracle - by which I mean
refering to the columns in the array by name rather than by index (ie
>-Original Message-
>From: Irsan Jie
>Sent: Monday, April 23, 2001 5:09 PM
>I try to connect to Oracle with PHP and get the error bellow:
>
>Warning: _oci_open_server: ORA-12699: Native service internal error in
>C:\htdocs\ccilinks.com\public_html\index.jies on line 8
>
>
>Do any body
, Ohio, USA
740-349-3631
Aliquando et insanire iucundum est
> -Original Message-
> From: Irsan Jie [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 11:09 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Oracle Connection Error
>
>
> I try to connect to Ora
I try to connect to Oracle with PHP and get the error bellow:
Warning: _oci_open_server: ORA-12699: Native service internal error in
C:\htdocs\ccilinks.com\public_html\index.jies on line 8
Do any body have any idea?
Irsan
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e
nual
Florian
"Asendorf, John" <[EMAIL PROTECTED]>
05.04.01 14:19
An: Florian Clever <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Kopie:
Thema: RE: [PHP-WIN] Oracle record counting
It's a bit long... and it's bastardized in that there are
//}
//else {
// echo "Unable to locate any customers with that search
criteria.\n";
//}
//free resources
OCIFreeStatement ( $stmt_search );
-
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http:/
Hi John,
your first example looks right. Can you send us the code you use to list
the records. I would expect the problem in there, because in your second
example basically the FetchStatement is not doing anything as the
statement has not been executed.
You need to loop through the result set arr
I'm attempting to work on a little oracle search...
My problem is that if I put the OCIExecute BEFORE the OCIFetchStatement
line, I get one error ( Warning: OCIFetchInto: ORA-01002: fetch out of
sequence in d:\InetPub\wwwroot\etc. ) but if I put OCIExecute AFTER the
OCIFetchStatement I get a diff
hello again,
I've solved my previous problem, thanks to Fernando Madruga (just quoting the file
name):
php "C:\Programmi\Apache Group\Apache\htdocs\test\phpinfo.php"
now, running my script from command-line (no more from the browser, where it works
fine) I get an oracle error ORA-12154 from my
I'm trying to connect to an Oracle database through ODBC using the
8.1.6 client and php4.04 or php4.05rc2 from www.php4win.de on NT with
servicepack 6 and IIS with php running as a cgi.
Php crashes at instruction 0x04c2ea86 referenced memory at
"0x0". The memory could not be writte
Hello !
> Hello: My name is Mike and I have little problem.How can I get a
connection
> to an ORACLE8i-database with php4?
> I can't find any documentation about it.
If you've a distant database you mut install Oracle client on your PHP
serveur.
For the connection the best solution is to use OC
Hello: My name is Mike and I have little problem.How can I get a connection
to an ORACLE8i-database with php4?
I can't find any documentation about it.
Regards
Mike
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EM
29 matches
Mail list logo
