Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    UK(berkshire)
    Posts
    11

    Unanswered: Caching results of Stored Procedure

    I was wondering if there is anyway to cache the results of a stored procedure in order to gain speed ?

    Or do I need to do something else clever ?

    Here is my SQL

    procedure spGetProcedureParams(v_procname in varchar2,
    v_packagename in varchar2,
    CurRef out typeRefCur,
    v_errcode out integer,
    v_errmesg out varchar2)

    is
    begin
    v_errcode :=0;
    open CurRef for
    select argument_name,
    data_type,
    NVL(pls_type,'REF'),
    in_out
    from user_arguments
    where upper(object_name) = upper(v_procname)
    and upper(package_name) = upper(v_packagename)
    order by sequence;
    exception
    when others then
    v_errcode :=SQLCODE;
    v_errmesg :=SQLERRM;
    end spGetProcedureParams;



    end pkgUtils;
    /
    Thanks

    youeee

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Caching results of Stored Procedure

    I'm not really sure what you are looking for. You could fetch the data into a collection like an index-by table. Whether this will improve performance depends on what you are going to do with it next.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •