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
