Forms 5.0 BLock work with Stored Procedures

From: Dietmar Frank <dfrank_at_fallet.com>
Date: Tue, 16 Jun 1998 16:49:46 +0200
Message-ID: <3586860A.6754@fallet.com>

How can I pass values to the WHERE-Statement I've only seen the possiblitlty
to work with an REF_Cursor and a static WHERE-Statement

procedure query (

   resultset in out <<REF_CURSOR>>) is
   begin

     open resultset for
       select * from emp
         where emp_no< 10;

   end;

--
Dietmar Frank
_

Fallet Software GmbH (((*)

Kirchgasse 9                       Tel    : +49 7032 / 9852 0           
(  \  
D-71154 Nufringen                  Fax    : +49 7032 / 9852 90          
(___\ 
Germany                            E-Mail : dfrank_at_fallet.com            

_||
Received on Tue Jun 16 1998 - 09:49:46 CDT