Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle and PHP with Cursors

Re: Oracle and PHP with Cursors

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 16 Nov 2007 16:57:29 -0800
Message-ID: <1195261042.784599@bubbleator.drizzle.com>


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.org
Received on Fri Nov 16 2007 - 18:57:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US