Oracle and PHP
From: hass_79 (hasna_79_at_hotmail-dot-com.no-spam.invalid)
Date: 04/13/04
- Next message: phpfreaks: "External/Internet IP"
- Previous message: Carl Wiles: "shouldnt this work?"
- Next in thread: Andy Hassall: "Re: Oracle and PHP"
- Reply: Andy Hassall: "Re: Oracle and PHP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 13 Apr 2004 03:25:11 -0500
hi all,
I use to get an error while retrieving data from oracle databse.
Warning: ociparse(): supplied argument is not a valid OCI8-Connection
resource in
Warning: ociexecute(): supplied argument is not a valid OCI8-Statement
resource in
Warning: ocirowcount(): supplied argument is not a valid
OCI8-Statement resource in
Warning: ocifetch (): supplied argument is not a valid OCI8-Statement
resource in
In the mean time Im not getting any error but its not
retrieving the data.
Part of my script:
<?php
iDBConn = ocilogon("TIGER", "SCOT",
"ORACLDB"); qGetEmployees = "SELECT STAFF_ENNAME
FROM HR_STAFF_MAST";
iStatement = @OCIParse( iDBConn, qGetEmployees);
@OCIExecute( iStatement, OCI_DEFAULT);
// check our query
arrError = OCIError( iStatement);
if ( arrError['code'])
{
print arrError['message'];
exit;
}
while (OCIFetch( iStatement) ) {
echo"<tr>";
if(!empty( iStatement))
{
result=OCIResult( iStatement, "STAFF_ENNAME");{
?>
I also tried oci_connect but i'm getting the following error
Fatal error: Call to undefined function: oci_connect()
My configuration: PHP Version 4.3.2, Apache 1.3, Windows 2000, Oracle
8i.
thanks
Please advise
hass_79
----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums
- Next message: phpfreaks: "External/Internet IP"
- Previous message: Carl Wiles: "shouldnt this work?"
- Next in thread: Andy Hassall: "Re: Oracle and PHP"
- Reply: Andy Hassall: "Re: Oracle and PHP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
