Bind variables with cursor refrences ?????

From: Roger <NOrgSPAM_at_mcs-hh.de>
Date: 2000/05/18
Message-ID: <8g1im3$l6n$1@garnet.hamburg.cityline.net>#1/1

Is it possible to use bind variables with cursor references ? For example I have the following declaration:

 CURSOR artikel_cur IS SELECT ARTIKEL.*, ROWID FROM ARTIKEL;

 TYPE t_artikel_cur IS REF CURSOR RETURN artikel_cur%ROWTYPE;

PROCEDURE findArtikel(p_artikel_cur IN OUT t_artikel_cur, p_first_value IN VARCHAR2)
IS

OPEN p_artikel_cur FOR

     SELECT /*+ INDEX_ASC (artikel artikel_name_idx) */ ARTIKEL.*, ROWID FROM ARTIKEL

                WHERE name > p_value;

END; Is it possible to use a bind variable instead of p_value ?

Regards

   Roger Received on Thu May 18 2000 - 00:00:00 CDT