owa_util.calanderprint

From: tony <meinhfx_at_hotmail.com>
Date: Fri, 19 Jul 2002 13:55:00 GMT
Message-ID: <3d381944.264797033@news.dal.ca>

Hi. I'm having difficulty implementing owa_util.calanderprint. Any idea what I'm doing wrong?

procedure printcal is

   v_text VARCHAR(10) := chr(39)||'myText'||chr(39);    p_theQuery VARCHAR(1000) := 'select activity_date , '||v_text||' from mytable order by activity_date'

                           ;
   begin
         htp.print(p_theQuery);
         owa_util.calendarprint(p_theQuery);
         EXCEPTION
            WHEN OTHERS THEN
               ...;

   end printcal;

This returns ORA-01007: variable not in select list.

thanks
cheers,
tony
902.494.1021 w
902.461.4550 h Received on Fri Jul 19 2002 - 08:55:00 CDT