Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle and PHP with Cursors
Björn Wächter wrote:
> Hi all,
>
> we are using Oracle and PHP for a Web application.
> We are using ref cursors to return data from oracle
> to php.
>
>
> PROCEDURE GetData(
> p_form IN VARCHAR2,
> crs_data OUT Usertype.ref_cursor
> )
> AS
> ...
> BEGIN
> ....
>
> OPEN crs_data FOR v_sql;
>
> END;
>
>
>
> CREATE OR REPLACE PACKAGE usertype AS
>
> TYPE ref_cursor IS REF CURSOR;
>
> END usertype;
>
>
> We are facing the problem that retrieving the data over
> the cursor is quite slow because we see in the trace that
> every row is request with one call to oracle. We enabled
> prefetching in PHP but as fare as we know this is not
> possible for cursors. We need the flexibility of cursors
> to be able to return different numbers of columns in each
> request.
> Any ideas how we can solve this problem?
> We read something about scrollable cursors. Is this a way?
>
> Thanks Björn
Oracle version number.
DDL would be helpful.
Information such as the number of rows being returned useful.
Is there a WHERE clause anywhere in sight?
Has the statement been tuned? How? With DBMS_XPLAN?
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Nov 16 2007 - 18:57:29 CST
![]() |
![]() |