owa_util.listprint question

From: AleX <korrozia_at_my-deja.com>
Date: Mon, 28 Jun 1999 20:04:42 GMT
Message-ID: <7l8kgh$r29$1@nnrp1.deja.com>

 Hi!

I have a simple pl/sql question.

I'm trying to create a select drop-down list for a pl/sql query. My code looks like this:

procedure session_selector

   is
   p_query varchar2(100);
   v_cursorID integer;
   begin
   htp.bodyopen;
   htp.formOpen ('presentation_builder.get_session_data');    p_query:='SELECT session_id FROM SESSION_LIST_TABLE';    v_cursorID:=owa_util.bind_variables (p_query);    owa_util.listprint (v_cursorID, 'p_value',10);

   htp.para;
   htp.formSubmit;
   htp.formclose;
   htp.bodyclose;

   end session_selector;

---

I get 'variable not in select list' when I run this procedure. However,   owa_util.cellsprint works just fine with the same cursor. I'm on 8.0.5 on NT. Please help!

--

                 Alex Shterenberg

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 28 1999 - 15:04:42 CDT