Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> pl/sql owa_util.listprint
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
![]() |
![]() |