stored procedure

From: Rafik <szkolenie_at_szkolenie.waw.pl>
Date: Sat, 19 May 2001 20:37:41 +0200
Message-ID: <9e6ekv$msd$1_at_news.tpi.pl>


[Quoted] Hi everyone,

I got a problem with following stored procedure which I put into a package. [Quoted] I bulit a form on the basis of this procedure and everything is ok BUT when [Quoted] I try to fetch records (by clicking F8) no records are fetched and form's closing itself automatticly.
I would be apprecieted for any tips in this matter. By the way, I am using 8.1.7 and Forms 6i.

CREATE OR REPLACE PACKAGE three IS

        TYPE blok_rekord IS RECORD (
        ename      emp.ename%TYPE,
        empno      emp.empno%TYPE);

TYPE cur_typ IS REF CURSOR RETURN blok_rekord; procedure pytanie(dane IN OUT cur_typ, where_value VARCHAR2); END; CREATE OR REPLACE PACKAGE BODY three IS

    procedure pytanie(dane IN OUT cur_typ, where_value VARCHAR2) IS     TYPE cur_typ IS REF CURSOR;
    c cur_typ;
    zm varchar2(1000);
    str varchar2(1000);
BEGIN

        str := 'SELECT empno, ename FROM emp WHERE '|| where_value;
        OPEN c FOR  str;
        CLOSE c;

END;
END; Received on Sat May 19 2001 - 20:37:41 CEST

Original text of this message