Re: PL/SQL returning a cursor to ODBC

Richard Katz wrote:
>
> How do I send a cursor back to the CLI (ODBC) from a PL/SQL stored
> procedure?
>
> I've tried declaring and openning a cursor. This doesn't seem to
> do anything. I'm guessing that there is some DBMS or UTL function
> that does this. Is there any documentation on how this is done?
>
> Many thanks,
>
> Richard Katz

Hi Richard,

select
> a.table_name, a.number_rows
> from
> (select
> count(*) number_rows, table_name
> from
> user_tables
> group by
> table_name
> ) a
> where
> a.number_rows > 0
> ; ?
>
 

-- 
Regards

Matthias Gresz    :-)