4 Replies Latest reply: Mar 7, 2011 9:43 AM by 707594 RSS

    poor performance by using ref cursor

    707594
      hi
      i have a stored procedure like :

      create or replace
      PROCEDURE "TEST" ( )
      as
      begin
      OPEN v_cv1 FOR
      SELECT * from
      table1 where rownum < 5;
      end;


      and when i call it with php (oci8) , executing is very fast but fetching the result will take about 15 seconds
      but if i run the query normally (without procedure) and just with select * ... it will take less than 1 sec

      can anyone help me to fix this?

      Edited by: Hossein Soodkhah on Mar 5, 2011 10:33 AM

      Edited by: Hossein Soodkhah on Mar 5, 2011 10:33 AM