[PHP-DB] Oracle8-Oracle7 and ref cursors, perhaps ociNewCollection?

[Theodore Hope]

I'm trying to use a stored procedure and ref cursors.
The PHP server has the Oracle 8.x client library and the
Oracle server is 7.x.  When I try to use the ref cursor
I get the infamous ORA-24370 error.  This error goes away
when I connect to an Oracle 8 server (and everything else,
including the stored procedure, stays the same).

Others have reported this error but I have yet to find a
work-around (and I can't upgrade the server to Oracle 8.x).
 
I'm wondering if there's a way to use ociNewCollection() and
have a stored procedure return an array of records (somehow)
and that way do away with the need for ref cursors, but
ociNewCollection() is under-documented to say the least :-(
 
Any tips or comments will be much appreciated. Thanks, -T.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] php 4 + Oracle 8 + FreeBSD w/ Linux Emulation

[Theodore Hope]

We're looking into getting PHP under FreeBSD (4.3) to talk to
a remote Oracle server that runs on NT.  In the past we have
used OpenLink, but we'd rather not touch anything on the NT
side.

It's apparent that one can install Oracle 8.x for Linux under
Linux emulation on FreeBSD.  My question is, will the link
(ld) of PHP + Apache + Oracle(Linux) work correctly under
this platform?

Thanks.  -T.H.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]