Subject: Re: [PHP3/4] Cursors in Oracle
| From: | Kim, Sung-Sik | Date: | Fri, 25 Feb 2000 15:04:14 +0000 |
| Subject: | Subject: Re: [PHP3/4] Cursors in Oracle | ||
| Groups: | php.version4 | ||
| Request: | Send a blank email to php-version4+get-10949@lists.php.net to get a copy of this message | ||
Here is my php script sample using oracle cursor.
i attached oracle_cursor.zip.
this file consist of 3 files
(Ocitest.sql, Cursor.sql, OCINewCursor.php3)
[execution step]
1. login with "scott/tiger" using SQL*PLUS
2. "hero" table creation.
=> Using Ocitest.sql
3. package creation
=> Using Cursor.sql
4. call "http://xxxxx/OCINewCursor.php3"
=> OCINewCursor.php3
This scripts shows hero table's all rows from resultset returned.
output in webbrowser
==============================
SUPERMAN : 30 : powerful :
SPIDERMAN : : speedy :
WONDER WOMAN : 25 : beautiful :
==============================
#################################################################################
WARNING:
i tested this script in php4b3/oracle8.0.5/redhat6.0/apache1.3.11 & php3.0.14/NT4/oracle8i/iis4.
works good.
But in php*4.0b4pl1* /oracle8.0.5/redhat6.0/apache1.3.11 throws *segment fault* error.
#################################################################################
Sorry poor english.
Attachment: [application/zip] oracle_cursor.zip
Attachment: [application/zip] oracle_cursor.zip