Oracle connection, tired eyes
| From: | Asendorf, John | Date: | Thu, 19 Oct 2000 21:21:55 +0000 |
| Subject: | Oracle connection, tired eyes | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-3392@lists.php.net to get a copy of this message | ||
The connection tests positive.
I can run the SQL in SQL*Plus and get 10 results
error returned is:
Warning: Supplied argument is not a valid OCI8-Statement resource in
D:\InetPub\wwwroot\is\website\test_center\testora.php on line 42 (the while
line - ja)
code is:
$sql = "select page from cfull2.resolution where page like 400";
$stmt = OCIParse($conn,$sql);
$ora_result = OCIExecute($stmt);
while (OCIFetch($ora_result)) { //line 42
$page = OCIresult ($ora_result, "page");
echo "$page <br />";
}
Anyone?
John
---------------------
Founder of
The 'What Kind of Idiot Uses PHP with IIS with Oracle on NT?' Consortium
Members: John Asendorf, Thomas Kryger
John Asendorf - jasendorf@lcounty.com
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631