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 -> pl/sql owa_util.listprint

pl/sql owa_util.listprint

From: tony <ttigger4321_at_hotmail.com>
Date: Fri, 05 Jul 2002 17:43:59 GMT
Message-ID: <3d25d9fd.186306994@news.dal.ca>


I'm having trouble implementing the listprint function. Can anyone tell me what I'm doing wrong?

procedure showlist is

   list_it boolean;

   p_theQuery VARCHAR(1000) := 'select object_name from all_objects';
   p_cname VARCHAR(10) := 'myList';
   p_nsize NUMBER(2) := 5;
   p_multiple BOOLEAN := FALSE;
   begin  
       list_it  := owa_util.listprint(p_theQuery, p_cname,
                    p_nsize,  p_multiple);
      EXCEPTION
         WHEN OTHERS THEN
            hylkserr.err_screen;
                 

end showlist;

Here's the error message from 8i on aix.

PLS-00222: no function with name 'LISTPRINT' exists in this scope

thanks
cheers,
tony
902.494.1021 w
902.461.4550 h Received on Fri Jul 05 2002 - 12:43:59 CDT

Original text of this message

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