Re: [PL/SQL] getting cursor metadata

Marcin Zawadzki wrote:

> How could I get cursor metadata from PL/SQL. ?
> In which system tables are stored information about open cursors ?
>
> MZ

On the theory that if you teach a man to fish he can feed himself ...

SELECT object_name, object_type
FROM all_objects
WHERE object_name LIKE '%OPEN%CURSOR%';

Modify this query to find information about anything in Oracle.

Daniel Morgan Received on Thu Oct 03 2002 - 10:05:00 CDT