Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: owa_util.calanderprint

Re: owa_util.calanderprint

From: tony <meinhfx_at_hotmail.com>
Date: Fri, 19 Jul 2002 14:17:08 GMT
Message-ID: <3d381f15.266285998@news.dal.ca>


Got it! This query works:

select activity_date , code, code

                                from mytable 
order by activity_date'

On Fri, 19 Jul 2002 13:55:00 GMT, meinhfx_at_hotmail.com (tony) wrote:

>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

cheers,
tony
902.494.1021 w
902.461.4550 h Received on Fri Jul 19 2002 - 09:17:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US