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>
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
END;
END; Received on Sat May 19 2001 - 20:37:41 CEST
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