Re: pl/sql owa_util.listprint

In message <3d2c2e53.89432915_at_news.dal.ca> , tony <ttigger4321_at_hotmail.com> writes
>On 6 Jul 2002 06:26:57 -0700, Thomas Kyte <tkyte_at_oracle.com> wrote:
>
>>In article <3d25d9fd.186306994_at_news.dal.ca>, ttigger4321_at_hotmail.com says...
>>>
>>>I'm having trouble implementing the listprint function. Can anyone
>>>tell me what I'm doing wrong?
>>>

>>> list_it := owa_util.listprint(p_theQuery, p_cname,
>>> p_nsize, p_multiple);
>>> EXCEPTION
>>> WHEN OTHERS THEN
>>> hylkserr.err_screen;

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

>>listprint is a procedure, not a function returning a boolean. It'll throw an
>>exception on error, not return a boolean "true" "false"
>>

>OK, I understand this, but can you tell me what is wrong with my
>implementation? Can you point me to any examples?

Well, you don't appear to understand the difference between a procedure and a function.

Try:

owa_util.listprint(p_theQuery, p_cname, p_nsize, p_multiple);

but bear in mind that the query should contain three columns - the first being what will be returned, the second being what the user sees and the third, if non-null, will flag whether the row was selected. In which case your query should be something like:

select object_id, object_name, null from all_objects

Andy

-- 
Andy Hardy. PGP ID: 0xA62A4849